Skip to main content

When I am in a page such as Part Cost and I want to search by Part Description, how can I find against which record in IFS this search is actually being performed? Is this using the Part, the Inventory Part, etc.? Is it being performed explicitly against this LU or an underlying LU or view?

 

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