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_ITEM_ATT_LOVS dependencies on RCV_SHIPMENT_HEADERS

Line 28: -- and rcv_shipment_headers to ensure the serials belongs to the ASN

24: Nvl(to_number(fnd_profile.value('INV_RESTRICT_RCPT_SER')), 2) = 2
25: )
26: -- Bug# 12556104 ASN Std receipt, add serial status = 5 (Resides in intransit)
27: -- and check existence in rcv_serials_supply join to rcv_shipment_lines
28: -- and rcv_shipment_headers to ensure the serials belongs to the ASN
29: OR (CURRENT_STATUS = 5 AND EXISTS (SELECT 1
30: FROM rcv_serials_supply rss
31: ,rcv_shipment_lines rsl
32: ,rcv_shipment_headers rsh

Line 32: ,rcv_shipment_headers rsh

28: -- and rcv_shipment_headers to ensure the serials belongs to the ASN
29: OR (CURRENT_STATUS = 5 AND EXISTS (SELECT 1
30: FROM rcv_serials_supply rss
31: ,rcv_shipment_lines rsl
32: ,rcv_shipment_headers rsh
33: WHERE rss.supply_type_code = 'SHIPMENT'
34: AND rss.serial_num = SERIAL_NUMBER
35: AND rss.shipment_line_id = rsl.shipment_line_id
36: AND rsh.shipment_header_id = rsl.shipment_header_id