APPS.BOM_COPY_ROUTING dependencies on BOM_BILL_OF_MATERIALS

Line 2042: FROM bom_bill_of_materials bom,

2038: FROM DUAL
2039: WHERE EXISTS (
2040: SELECT 1
2041: /* Checking for the BOM components operation seq. num. for primary */
2042: FROM bom_bill_of_materials bom,
2043: bom_component_operations bco
2044: WHERE bom.organization_id = p_org_id
2045: AND bom.assembly_item_id = p_ass_itm_id
2046: AND bom.alternate_bom_designator IS NULL

Line 2051: FROM bom_bill_of_materials bom,

2047: AND bom.bill_sequence_id = bco.bill_sequence_id)
2048: OR EXISTS (
2049: SELECT 1
2050: /* Checking for the BOM components operation seq. num. for primary*/
2051: FROM bom_bill_of_materials bom,
2052: bom_inventory_components bic
2053: WHERE bom.organization_id = p_org_id
2054: AND bom.assembly_item_id = p_ass_itm_id
2055: AND bom.alternate_bom_designator IS NULL

Line 2061: FROM bom_bill_of_materials bom,

2057: AND bic.operation_seq_num > 1)
2058: OR EXISTS (
2059: SELECT 1
2060: /* Checking for the BOM components operation seq. num. for alternate */
2061: FROM bom_bill_of_materials bom,
2062: bom_component_operations bco
2063: WHERE bom.organization_id = p_org_id
2064: AND bom.assembly_item_id = p_ass_itm_id
2065: AND bom.alternate_bom_designator = p_alt_rtg_desg

Line 2070: FROM bom_bill_of_materials bom,

2066: AND bom.bill_sequence_id = bco.bill_sequence_id)
2067: OR EXISTS (
2068: SELECT 1
2069: /* Checking for the BOM components operation seq. num. for alternate */
2070: FROM bom_bill_of_materials bom,
2071: bom_inventory_components bic
2072: WHERE bom.organization_id = p_org_id
2073: AND bom.assembly_item_id = p_ass_itm_id
2074: AND bom.alternate_bom_designator = p_alt_rtg_desg