Community,
kindly assist on the SQL query we are building for API method Inventory_Part_Config_Api.Get_Latest_Purchase_Price()
what parameters we should pass to method Get_Latest_Purchase_Price()?
Thank you.
Solved
inventory_part_config_api.get_latest_purchase_price()
Best answer by kvbe
The Inventory_Part_Config_Api.Get_Latest_Purchase_Price() method takes the following parameters:
Parameters:
1. contract_ (VARCHAR2) - The site/contract
2. part_no_ (VARCHAR2) - The part number
3. configuration_id_ (VARCHAR2) - The configuration ID (typically '*' for non-configured parts)
Method signature:
Inventory_Part_Config_API.Get_Latest_Purchase_Price(contract_, part_no_, configuration_id_)
For example
Inventory_Part_Config_API.Get_Latest_Purchase_Price(CONTRACT, PART_NO, '*')
This method retrieves the latest purchase price for a specific part configuration from the INVENTORY_PART_CONFIG_TAB table
Hope that helps
The Inventory_Part_Config_Api.Get_Latest_Purchase_Price() method takes the following parameters:
Parameters:
1. contract_ (VARCHAR2) - The site/contract
2. part_no_ (VARCHAR2) - The part number
3. configuration_id_ (VARCHAR2) - The configuration ID (typically '*' for non-configured parts)
Method signature:
Inventory_Part_Config_API.Get_Latest_Purchase_Price(contract_, part_no_, configuration_id_)
For example
Inventory_Part_Config_API.Get_Latest_Purchase_Price(CONTRACT, PART_NO, '*')
This method retrieves the latest purchase price for a specific part configuration from the INVENTORY_PART_CONFIG_TAB table
Hope that helps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.