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.INVPVALM dependencies on MTL_SYSTEM_ITEMS_VL

Line 907: to mtl_system_items_vl

903: end; /* MASTER_CHILD_1F */
904:
905: /*Bug 1529259
906: In the following query changed the Table Name from mtl_system_item_b
907: to mtl_system_items_vl
908: This is to get the correct description
909: */
910: --5446889 ADDED check for long_description
911: begin /* MASTER_CHILD_1G */

Line 914: from mtl_system_items_VL msi

910: --5446889 ADDED check for long_description
911: begin /* MASTER_CHILD_1G */
912:
913: select inventory_item_id into msicount
914: from mtl_system_items_VL msi
915: where msi.inventory_item_id = cr.III
916: and msi.organization_id = cr.MORGID
917: and decode(A_RECEIPT_DAYS_EXCEPTION_CODE,X_TRUE,nvl(cr.RECEIPT_DAYS_EXCEPTION_CODE,-1),nvl(msi.RECEIPT_DAYS_EXCEPTION_CODE,-1))=nvl(msi.RECEIPT_DAYS_EXCEPTION_CODE,-1)
918: and decode(A_RECEIVING_ROUTING_ID,X_TRUE,nvl(cr.RECEIVING_ROUTING_ID,-1),nvl(msi.RECEIVING_ROUTING_ID,-1))=nvl(msi.RECEIVING_ROUTING_ID,-1)