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_PVT2 dependencies on RCV_SERIALS_SUPPLY

Line 168: -- rcv_serials_supply may not be populated. This information has been derived from talking to the Inbound

164: -- input parameter. The item id is being derived from the rcv_shipment_lines because irrespective of the
165: -- transaction type(Receipt or Internal Req), the item id will be populated. For Internal Requisitions, the
166: -- pol.item_id may not be populated. This cursor is common for everything except a deliver transaction . This
167: -- is taken care of in teh second part of the SQL(after the UNION ALL) since for Deliver transactions, the
168: -- rcv_serials_supply may not be populated. This information has been derived from talking to the Inbound
169: -- team.
170: -- SELECT to_number(null) inventory_item_id
171: SELECT rsl.item_id inventory_item_id -- @@@ Bug 3472432
172: , rt.organization_id organization_id

Line 189: FROM rcv_transactions rt, rcv_serials_supply rss, po_lines_all pol

185: , rt.vendor_site_id
186: , rt.uom_code
187: , rt.oe_order_header_id --Bug 4582954
188: , rt.oe_order_line_id --Bug 4582954
189: FROM rcv_transactions rt, rcv_serials_supply rss, po_lines_all pol
190: -- , po_distributions_all pod --Commented as part of Bug# 3586116
191: , po_headers_all pha, rcv_shipment_lines rsl
192: , wms_license_plate_numbers wlpn -- Bug 3836623
193: WHERE rss.transaction_id = rt.transaction_id