DBA Data[Home] [Help]

APPS.BOM_COPY_ROUTING dependencies on BOM_INVENTORY_COMPONENTS

Line 2052: bom_inventory_components bic

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
2056: AND bom.bill_sequence_id = bic.bill_sequence_id

Line 2071: bom_inventory_components bic

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
2075: AND bom.bill_sequence_id = bic.bill_sequence_id