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_GLOBALS dependencies on MTL_SYSTEM_ITEMS_B

Line 2180: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2176: (SELECT NVL(mirb.lifecycle_id, msi.lifecycle_id) AS lifecycle_id,
2177: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2178: msi.item_catalog_group_id item_catalog_group_id,
2179: msi.inventory_item_id, msi.organization_id , mirb.revision_id
2180: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2181: WHERE msi.INVENTORY_ITEM_ID = p_item_id
2182: AND msi.ORGANIZATION_ID = p_org_id
2183: AND mirb.revision_id = nvl(p_rev_id,BOM_Revisions.Get_Item_Revision_Id_Fn('ALL','ALL',p_org_id, p_item_id, p_rev_date) )
2184: AND (mirb.current_phase_id IS NOT NULL OR msi.current_phase_id IS NOT NULL)) ITEM_DTLS,

Line 2257: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi

2253: (SELECT NVL(mirb.lifecycle_id, msi.lifecycle_id) AS lifecycle_id,
2254: NVL(mirb.current_phase_id , msi.current_phase_id) AS phase_id,
2255: msi.item_catalog_group_id item_catalog_group_id,
2256: msi.inventory_item_id, msi.organization_id , mirb.revision
2257: FROM mtl_item_revisions_b mirb, MTL_SYSTEM_ITEMS_b msi
2258: WHERE msi.INVENTORY_ITEM_ID = p_item_id
2259: AND msi.ORGANIZATION_ID = p_org_id
2260: AND mirb.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID
2261: AND mirb.ORGANIZATION_ID = msi.ORGANIZATION_ID