How to see against which LU or view a search is being performed

Hi ​@matt.watters,

Need to check system calls in the debug console. I quickly checked to see what system calls when passing any random input for Description.

Description for the Part Cost screen is mapped using the Inventory_Part_API.

Please check the select statement below that calls while querying data for the Part Cost screen.

SELECT * FROM (SELECT A.* FROM (SELECT part_no part_no, cost_set cost_set, contract contract, alternative_no alternative_no, routing_alternative_no routing_alternative_no, Inventory_Part_API.Get_Description(contract, part_no) description, cost_template_id cost_template_id, part_cost_group_id part_cost_group_id, effective_date effective_date, effective_serial_no effective_serial_no, total_level_cost total_level_cost, total_accum_cost total_accum_cost, level_sales_cost level_sales_cost, total_sales_cost total_sales_cost, calculation_date calculation_date, cost_estimator_id cost_estimator_id, Manuf_Part_Attribute_API.Get_Manuf_Engineer(CONTRACT, PART_NO) manuf_engineer, type_code_db type_code, last_activity_date last_activity_date, std_order_size std_order_size, decode(use_latest_val_str_rev_db, 'TRUE' , 'TRUE', 'FALSE') use_latest_val_str_rev_db, cost_calculation_status_db cost_calculation_status, end_item_db end_item, kaizen_cost kaizen_cost, TOTAL_ACCUM_COST - KAIZEN_COST kaizen_cost_gap, mandatory_cost_reduction_db mandatory_cost_reduction, required_reduction_date required_reduction_date, DECODE(PART_CATALOG_API.Get_Configurable_Db(PART_NO), 'CONFIGURED', 'TRUE', 'FALSE') configurable, NULL objgrants, 'PartCost' luname, 'ALTERNATIVE_NO='||alternative_no||'^'||'CONTRACT='||contract||'^'||'COST_SET='||cost_set||'^'||'PART_NO='||part_no||'^'||'ROUTING_ALTERNATIVE_NO='||routing_alternative_no||'^' keyref, contract objsite, 'W/"'||objid||':'||objversion||'"' etag FROM PART_COST) A) WHERE (((LOWER(description)) LIKE 'simple' || '%')) ORDER BY part_no ASC, contract ASC, cost_set ASC, alternative_no ASC, routing_alternative_no ASC FETCH FIRST 25 ROWS ONLY

Regards

Abdul Rehman