eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DELETE_ITEMS dependencies on MTL_ITEM_FLEXFIELDS

Line 258: MTL_ITEM_FLEXFIELDS MIF

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
262: AND MIF.ORGANIZATION_ID = MCSI.ORGANIZATION_ID

Line 319: MTL_ITEM_FLEXFIELDS MIF

315: last_login_id
316: FROM
317: MTL_CATALOG_SEARCH_ITEMS MCSI,
318: BOM_BILL_OF_MATERIALS BOM,
319: MTL_ITEM_FLEXFIELDS MIF
320: WHERE MCSI.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID
321: AND MCSI.ORGANIZATION_ID = BOM.ORGANIZATION_ID
322: AND MIF.ITEM_ID = MCSI.INVENTORY_ITEM_ID
323: AND MIF.ORGANIZATION_ID = MCSI.ORGANIZATION_ID

Line 378: MTL_ITEM_FLEXFIELDS MIF

374: last_login_id
375: FROM
376: MTL_CATALOG_SEARCH_ITEMS MCSI,
377: BOM_OPERATIONAL_ROUTINGS BOR,
378: MTL_ITEM_FLEXFIELDS MIF
379: WHERE MCSI.ORGANIZATION_ID = org_id
380: AND MCSI.INVENTORY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID
381: AND MCSI.ORGANIZATION_ID = BOR.ORGANIZATION_ID
382: AND MIF.ITEM_ID = MCSI.INVENTORY_ITEM_ID

Line 448: MTL_ITEM_FLEXFIELDS MIF

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
452: AND MIF.ORGANIZATION_ID = BOM.ORGANIZATION_ID

Line 504: MTL_ITEM_FLEXFIELDS MIF

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
508: AND MSI.ORGANIZATION_ID = BOM.ORGANIZATION_ID

Line 572: MTL_ITEM_FLEXFIELDS MIF

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
576: AND MIF.ORGANIZATION_ID = BOM.ORGANIZATION_ID

Line 640: MTL_ITEM_FLEXFIELDS MIF

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
644: AND MSI.ORGANIZATION_ID = BOM.ORGANIZATION_ID

Line 702: MTL_ITEM_FLEXFIELDS MIF

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
706: AND MIF.ITEM_ID = BOR.ASSEMBLY_ITEM_ID

Line 850: MTL_ITEM_FLEXFIELDS MIF

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
854: AND MIF.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Line 925: MTL_ITEM_FLEXFIELDS MIF

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
929: AND MSI.ORGANIZATION_ID = BOM.ORGANIZATION_ID

Line 977: MTL_ITEM_FLEXFIELDS MIF

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
981: AND MSI.ORGANIZATION_ID = BOR.ORGANIZATION_ID