[Home] [Help]
163: * becuase it is possible for label-API to be called multiple times by RCV-TM
164: * in the case of ROI, when multiple trx.types are present in a group
165: */
166: -- Commented as part of fix for bug Bug 3472432. The l_inventory_item_id is required for the serial_cur as an
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
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
197: , wms_license_plate_numbers wlpn -- Bug 3836623
198: WHERE rss.transaction_id = rt.transaction_id
199: AND pol.po_line_id(+) = rt.po_line_id
200: AND pha.po_header_id(+) = rt.po_header_id
243: , mtl_unit_transactions mut
244: -- , po_distributions_all pod --Commented as part of Bug# 3586116
245: , po_lines_trx_v pol -- CLM project, bug 9403291
246: , po_headers_trx_v pha -- CLM project, bug 9403291
247: , rcv_shipment_lines rsl
248: , wms_license_plate_numbers wlpn -- Bug 3836623
249: -- Bug 4179732, can not print serial number from putaway
250: -- Changed to link to MUT through MMT
251: , mtl_material_transactions mmt