Using API BOMPXINQ.Export_BOM
We are planning to use API BOMPXINQ.Export_BOM for exploding BOM and use temp table (BOM_SMALL_EXPL_TEMP) to extract levels
PROCEDURE Export_BOM ( Profile_id IN NUMBER ,
Org_hierarchy_name IN VARCHAR2,
Assembly_item_id IN NUMBER,
Organization_id IN NUMBER,
Alternate_bm_designator IN VARCHAR2 DEFAULT '',
Costs IN NUMBER DEFAULT 2,
Cost_type_id IN NUMBER DEFAULT 0,
bom_export_tab OUT NOCOPY bomexporttabtype,
Err_Msg OUT NOCOPY VARCHAR2,
Error_Code OUT NOCOPY NUMBER );
Among input parameters for profile_id and Org_hierarchy_name how values can be derived from Oracle and pass to this API is there any setup for this