APPS.BOM_COPY_ROUTING dependencies on BOM_BILL_OF_MATERIALS

Line 2106: FROM bom_bill_of_materials bom,

2102: FROM DUAL
2103: WHERE EXISTS (
2104: SELECT 1
2105: /* Checking for the BOM components operation seq. num. for primary */
2106: FROM bom_bill_of_materials bom,
2107: bom_component_operations bco
2108: WHERE bom.organization_id = p_org_id
2109: AND bom.assembly_item_id = p_ass_itm_id
2110: AND bom.alternate_bom_designator IS NULL

Line 2115: FROM bom_bill_of_materials bom,

2111: AND bom.bill_sequence_id = bco.bill_sequence_id)
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

Line 2125: FROM bom_bill_of_materials bom,

2121: AND bic.operation_seq_num > 1)
2122: OR EXISTS (
2123: SELECT 1
2124: /* Checking for the BOM components operation seq. num. for alternate */
2125: FROM bom_bill_of_materials bom,
2126: bom_component_operations bco
2127: WHERE bom.organization_id = p_org_id
2128: AND bom.assembly_item_id = p_ass_itm_id
2129: AND bom.alternate_bom_designator = p_alt_rtg_desg

Line 2134: FROM bom_bill_of_materials bom,

2130: AND bom.bill_sequence_id = bco.bill_sequence_id)
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