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 171: -- rcv_serials_supply may not be populated. This information has been derived from talking to the Inbound

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

Line 192: FROM rcv_transactions rt, rcv_serials_supply rss,

188: , rt.vendor_site_id
189: , rt.uom_code
190: , rt.oe_order_header_id --Bug 4582954
191: , rt.oe_order_line_id --Bug 4582954
192: FROM rcv_transactions rt, rcv_serials_supply rss,
193: po_lines_trx_v pol -- CLM project, bug 9403291
194: -- , po_distributions_all pod --Commented as part of Bug# 3586116
195: , po_headers_trx_v pha, -- CLM project, bug 9403291
196: rcv_shipment_lines rsl