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 BOM_BILL_OF_MATERIALS

Line 318: BOM_BILL_OF_MATERIALS BOM,

314: userid,
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

Line 446: BOM_BILL_OF_MATERIALS BOM,

442: SYSDATE,
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

Line 456: BOM_BILL_OF_MATERIALS BOM,

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

Line 502: BOM_BILL_OF_MATERIALS BOM,

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

Line 570: BOM_BILL_OF_MATERIALS BOM,

566: SYSDATE,
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

Line 580: BOM_BILL_OF_MATERIALS BOM,

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

Line 638: BOM_BILL_OF_MATERIALS BOM,

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

Line 923: BOM_BILL_OF_MATERIALS BOM,

919: userid,
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