DBA Data[Home] [Help]

APPS.BOM_DELETE_ITEMS dependencies on MTL_SYSTEM_ITEMS

Line 257: MTL_SYSTEM_ITEMS MSI,

253: userid,
254: last_login_id
255: FROM
256: MTL_CATALOG_SEARCH_ITEMS MCSI,
257: MTL_SYSTEM_ITEMS MSI,
258: MTL_ITEM_FLEXFIELDS MIF
259: WHERE MSI.INVENTORY_ITEM_ID = MCSI.INVENTORY_ITEM_ID
260: AND MSI.ORGANIZATION_ID = MCSI.ORGANIZATION_ID
261: AND MIF.ITEM_ID = MCSI.INVENTORY_ITEM_ID

Line 447: MTL_SYSTEM_ITEMS MSI,

443: userid,
444: last_login_id
445: FROM
446: BOM_BILL_OF_MATERIALS BOM,
447: MTL_SYSTEM_ITEMS MSI,
448: MTL_ITEM_FLEXFIELDS MIF
449: WHERE MSI.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID
450: AND MSI.ORGANIZATION_ID = BOM.ORGANIZATION_ID
451: AND MIF.ITEM_ID = BOM.ASSEMBLY_ITEM_ID

Line 503: MTL_SYSTEM_ITEMS MSI,

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
505: WHERE BOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
506: AND BDE.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
507: AND MSI.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID

Line 571: MTL_SYSTEM_ITEMS MSI,

567: userid,
568: last_login_id
569: FROM
570: BOM_BILL_OF_MATERIALS BOM,
571: MTL_SYSTEM_ITEMS MSI,
572: MTL_ITEM_FLEXFIELDS MIF
573: WHERE MSI.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID
574: AND MSI.ORGANIZATION_ID = BOM.ORGANIZATION_ID
575: AND MIF.ITEM_ID = BOM.ASSEMBLY_ITEM_ID

Line 639: MTL_SYSTEM_ITEMS MSI,

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
641: WHERE BOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
642: AND BDE.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
643: AND MSI.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID

Line 701: MTL_SYSTEM_ITEMS MSI,

697: userid,
698: last_login_id
699: FROM
700: BOM_OPERATIONAL_ROUTINGS BOR,
701: MTL_SYSTEM_ITEMS MSI,
702: MTL_ITEM_FLEXFIELDS MIF
703: WHERE BOR.ORGANIZATION_ID = org_id
704: AND MSI.INVENTORY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID
705: AND MSI.ORGANIZATION_ID = BOR.ORGANIZATION_ID

Line 849: MTL_SYSTEM_ITEMS MSI,

845: userid,
846: SYSDATE,
847: userid
848: FROM
849: MTL_SYSTEM_ITEMS MSI,
850: MTL_ITEM_FLEXFIELDS MIF
851: WHERE MSI.INVENTORY_ITEM_ID = GetDelEntitiesREC.INVENTORY_ITEM_ID
852: AND MSI.ENG_ITEM_FLAG = item_eng_flag
853: AND MIF.ITEM_ID = MSI.INVENTORY_ITEM_ID

Line 924: MTL_SYSTEM_ITEMS MSI,

920: SYSDATE,
921: userid
922: FROM
923: BOM_BILL_OF_MATERIALS BOM,
924: MTL_SYSTEM_ITEMS MSI,
925: MTL_ITEM_FLEXFIELDS MIF
926: WHERE ASSEMBLY_ITEM_ID = BR_GetDelEntitiesREC.INVENTORY_ITEM_ID
927: AND BOM.ORGANIZATION_ID = BR_GetDelEntitiesREC.ORGANIZATION_ID
928: AND MSI.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID

Line 976: MTL_SYSTEM_ITEMS MSI,

972: SYSDATE,
973: userid
974: FROM
975: BOM_OPERATIONAL_ROUTINGS BOR,
976: MTL_SYSTEM_ITEMS MSI,
977: MTL_ITEM_FLEXFIELDS MIF
978: WHERE ASSEMBLY_ITEM_ID = BR_GetDelEntitiesREC.INVENTORY_ITEM_ID
979: AND BOR.ORGANIZATION_ID = BR_GetDelEntitiesREC.ORGANIZATION_ID
980: AND MSI.INVENTORY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID