APPS.MODAL_DELETE dependencies on MTL_SYSTEM_ITEMS_KFV

Line 91: FROM MTL_SYSTEM_ITEMS_KFV MSIK,

87: BIC.OPERATION_SEQ_NUM,
88: BIC.COMPONENT_ITEM_ID,
89: MSIK.CONCATENATED_SEGMENTS,
90: MSIK.DESCRIPTION
91: FROM MTL_SYSTEM_ITEMS_KFV MSIK,
92: BOM_INVENTORY_COMPONENTS BIC
93: WHERE BIC.COMPONENT_SEQUENCE_ID = ent_comp_seq_id
94: AND MSIK.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
95: AND MSIK.ORGANIZATION_ID = org_id

Line 240: FROM MTL_SYSTEM_ITEMS_KFV MSIK

236: NULL,
237: NULL,
238: NULL,
239: NULL
240: FROM MTL_SYSTEM_ITEMS_KFV MSIK
241: WHERE MSIK.INVENTORY_ITEM_ID = ent_inv_item_id
242: AND MSIK.ORGANIZATION_ID = org_id;
243: End loop; -- new entity
244: End if; -- entity did not exist

Line 464: FROM MTL_SYSTEM_ITEMS_KFV MSIK,

460: BIC.OPERATION_SEQ_NUM,
461: BIC.COMPONENT_ITEM_ID,
462: MSIK.CONCATENATED_SEGMENTS,
463: MSIK.DESCRIPTION
464: FROM MTL_SYSTEM_ITEMS_KFV MSIK,
465: BOM_INVENTORY_COMPONENTS BIC
466: WHERE BIC.COMPONENT_SEQUENCE_ID = ent_comp_seq_id
467: AND MSIK.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
468: AND MSIK.ORGANIZATION_ID = org_id

Line 650: FROM MTL_SYSTEM_ITEMS_KFV MSIK

646: l_RequestId,
647: l_ApplicationId,
648: l_ProgramId,
649: sysdate
650: FROM MTL_SYSTEM_ITEMS_KFV MSIK
651: WHERE MSIK.INVENTORY_ITEM_ID = ent_inv_item_id
652: AND MSIK.ORGANIZATION_ID = org_id;
653: End loop; -- new entity
654: End if; -- entity did not exist