APPS.CSTPSCEX dependencies on BOM_PARAMETERS

Line 428: bom_parameters bp

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

Line 780: bom_parameters bp /* Bug 4547027 */

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

Line 816: bom_parameters bp /* Bug 4547027 */

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

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

1482: l_stmt_num number(15);
1483:
1484: l_timestamp date;
1485:
1486: l_no_bom_org number(15); -- SCAPI: check for bom parameters setup
1487:
1488: l_report_levels number(15); -- := i_report_levels; commented to remove GSCC warning
1489:
1490: begin