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.INV_LABEL dependencies on MTL_ITEM_REVISIONS_B

Line 3779: FROM MTL_CROSS_REFERENCES MCR, MTL_ITEM_REVISIONS_B MIR

3775: IF(G_PROFILE_GTIN IS NOT NULL) THEN
3776:
3777: SELECT MCR.CROSS_REFERENCE, MCR.DESCRIPTION, MCR.REVISION_ID, MCR.UOM_CODE
3778: INTO x_gtin, x_gtin_desc, l_revision_id, l_uom_code
3779: FROM MTL_CROSS_REFERENCES MCR, MTL_ITEM_REVISIONS_B MIR
3780: WHERE MIR.INVENTORY_ITEM_ID = MCR.INVENTORY_ITEM_ID
3781: AND MIR.REVISION_ID = NVL(MCR.REVISION_ID, MIR.REVISION_ID)
3782: AND MIR.INVENTORY_ITEM_ID = p_inventory_item_id
3783: AND (( mcr.org_independent_flag = 'Y' AND mcr.organization_id IS NULL AND MIR.organization_id = p_organization_id) OR (mcr.org_independent_flag = 'N' AND mcr.organization_id = p_organization_id AND mcr.organization_id = mir.organization_id))