DBA Data[Home] [Help]

APPS.BOM_COPY_ROUTING dependencies on BOM_INVENTORY_COMPONENTS

Line 2116: bom_inventory_components bic

2112: OR EXISTS (
2113: SELECT 1
2114: /* Checking for the BOM components operation seq. num. for primary*/
2115: FROM bom_bill_of_materials bom,
2116: bom_inventory_components bic
2117: WHERE bom.organization_id = p_org_id
2118: AND bom.assembly_item_id = p_ass_itm_id
2119: AND bom.alternate_bom_designator IS NULL
2120: AND bom.bill_sequence_id = bic.bill_sequence_id

Line 2135: bom_inventory_components bic

2131: OR EXISTS (
2132: SELECT 1
2133: /* Checking for the BOM components operation seq. num. for alternate */
2134: FROM bom_bill_of_materials bom,
2135: bom_inventory_components bic
2136: WHERE bom.organization_id = p_org_id
2137: AND bom.assembly_item_id = p_ass_itm_id
2138: AND bom.alternate_bom_designator = p_alt_rtg_desg
2139: AND bom.bill_sequence_id = bic.bill_sequence_id