APPS.CSTPSCEX dependencies on BOM_PARAMETERS

Line 429: bom_parameters bp

425: select decode(nvl(msi.inventory_item_status_code,'NOT'||bp.bom_delete_status_code),
426: nvl(bp.bom_delete_status_code,' '),2,1)
427: into l_active_flag
428: from mtl_system_items msi,
429: bom_parameters bp
430: where msi.inventory_item_id = CSBE.component_item_id
431: and msi.organization_id = CSBE.component_organization_id
432: and bp.organization_id (+) = msi.organization_id;
433: /*Added exception to avoid the request erroring due to incorrect sourcing rule set*/

Line 782: bom_parameters bp /* Bug 4547027 */

778: cst_sc_bom_structures CSBS,
779: cst_item_costs CIC,
780: mtl_system_items MSI,
781: bom_inventory_components BIC,
782: bom_parameters bp /* Bug 4547027 */
783: where
784: CSBS.rollup_id = i_rollup_id and
785: CSBS.assembly_item_id = -1 and
786: CIC.inventory_item_id (+) = CSBS.top_inventory_item_id and

Line 818: bom_parameters bp /* Bug 4547027 */

814: cst_sc_bom_structures CSBS,
815: cst_item_costs CIC,
816: mtl_system_items MSI,
817: bom_inventory_components BIC,
818: bom_parameters bp /* Bug 4547027 */
819: where
820: CSBS.rollup_id = i_rollup_id and
821: CSBS.assembly_item_id <> -1 and
822: CIC.inventory_item_id (+) = CSBS.assembly_item_id and

Line 1529: l_no_bom_org number(15); -- SCAPI: check for bom parameters setup

1525: l_stmt_num number(15);
1526:
1527: l_timestamp date;
1528:
1529: l_no_bom_org number(15); -- SCAPI: check for bom parameters setup
1530:
1531: l_report_levels number(15); -- := i_report_levels; commented to remove GSCC warning
1532:
1533: begin