DBA Data[Home] [Help]

APPS.BOM_DELETE_ITEMS dependencies on BOM_INVENTORY_COMPONENTS

Line 457: BOM_INVENTORY_COMPONENTS BIC

453: AND BOM.BILL_SEQUENCE_ID IN(
454: SELECT DISTINCT BOM.BILL_SEQUENCE_ID
455: FROM
456: BOM_BILL_OF_MATERIALS BOM,
457: BOM_INVENTORY_COMPONENTS BIC
458: WHERE BOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
459: AND BOM.ORGANIZATION_ID = org_id
460: AND BOM.ASSEMBLY_TYPE = eng_flag
461: AND expiration_date >= BIC.DISABLE_DATE

Line 500: BOM_INVENTORY_COMPONENTS BIC,

496: SYSDATE,
497: userid,
498: last_login_id
499: FROM
500: BOM_INVENTORY_COMPONENTS BIC,
501: BOM_DELETE_ENTITIES BDE,
502: BOM_BILL_OF_MATERIALS BOM,
503: MTL_SYSTEM_ITEMS MSI,
504: MTL_ITEM_FLEXFIELDS MIF

Line 581: BOM_INVENTORY_COMPONENTS BIC

577: AND BOM.BILL_SEQUENCE_ID IN(
578: SELECT DISTINCT BOM.BILL_SEQUENCE_ID
579: FROM
580: BOM_BILL_OF_MATERIALS BOM,
581: BOM_INVENTORY_COMPONENTS BIC
582: WHERE BOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
583: AND BOM.ORGANIZATION_ID = org_id
584: AND BOM.ASSEMBLY_TYPE = eng_flag
585: AND BIC.COMPONENT_ITEM_ID = component_id

Line 636: BOM_INVENTORY_COMPONENTS BIC,

632: SYSDATE,
633: userid,
634: last_login_id
635: FROM
636: BOM_INVENTORY_COMPONENTS BIC,
637: BOM_DELETE_ENTITIES BDE,
638: BOM_BILL_OF_MATERIALS BOM,
639: MTL_SYSTEM_ITEMS MSI,
640: MTL_ITEM_FLEXFIELDS MIF