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_CROSS_REFERENCES

Line 3859: FROM MTL_CROSS_REFERENCES MCR, MTL_ITEM_REVISIONS_B MIR

3855: IF (p_revision IS NOT NULL) THEN
3856:
3857: SELECT MCR.CROSS_REFERENCE, MCR.DESCRIPTION, MCR.REVISION_ID, MCR.UOM_CODE
3858: INTO x_gtin, x_gtin_desc, l_revision_id, l_uom_code
3859: FROM MTL_CROSS_REFERENCES MCR, MTL_ITEM_REVISIONS_B MIR
3860: WHERE CROSS_REFERENCE_TYPE = G_PROFILE_GTIN
3861: AND MIR.INVENTORY_ITEM_ID = MCR.INVENTORY_ITEM_ID
3862: AND MIR.INVENTORY_ITEM_ID = p_inventory_item_id
3863: AND MIR.REVISION_ID = nvl(MCR.REVISION_ID,MIR.REVISION_ID)

Line 3875: FROM MTL_CROSS_REFERENCES MCR

3871: ELSE
3872:
3873: SELECT MCR.CROSS_REFERENCE, MCR.DESCRIPTION, MCR.REVISION_ID, MCR.UOM_CODE
3874: INTO x_gtin, x_gtin_desc, l_revision_id, l_uom_code
3875: FROM MTL_CROSS_REFERENCES MCR
3876: WHERE CROSS_REFERENCE_TYPE = G_PROFILE_GTIN
3877: AND MCR.INVENTORY_ITEM_ID = p_inventory_item_id
3878: AND MCR.REVISION_ID IS NULL
3879: AND (