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_UI_RCV_LOVS dependencies on MTL_SUPPLY

Line 663: FROM mtl_supply ms

659: AND sl.to_organization_id = p_organization_id
660: AND sh.receipt_source_code IN ('INTERNAL ORDER','INVENTORY')
661: AND exists
662: (SELECT 'available supply'
663: FROM mtl_supply ms
664: WHERE ms.to_organization_id = p_organization_id
665: AND ms.shipment_header_id = sh.shipment_header_id)
666: -- This was fix for bug 2740648/2752094
667: AND sl.shipment_line_status_code in ('EXPECTED','PARTIALLY RECEIVED')

Line 2109: FROM mtl_supply ms

2105: AND EXISTS
2106: (
2107: SELECT
2108: 'available supply'
2109: FROM mtl_supply ms
2110: WHERE ms.to_organization_id = p_organization_id
2111: AND ms.shipment_header_id = sh.shipment_header_id
2112: )
2113: -- This was fix for bug 2740648/2752094

Line 2747: FROM mtl_supply ms

2743: AND EXISTS
2744: (
2745: SELECT
2746: 'available supply'
2747: FROM mtl_supply ms
2748: WHERE ms.to_organization_id = p_organization_id
2749: AND ms.shipment_header_id = sh.shipment_header_id
2750: )
2751: -- This was fix for bug 2740648/2752094