[Home] [Help]
160: * becuase it is possible for label-API to be called multiple times by RCV-TM
161: * in the case of ROI, when multiple trx.types are present in a group
162: */
163: -- Commented as part of fix for bug Bug 3472432. The l_inventory_item_id is required for the serial_cur as an
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
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
194: AND pol.po_line_id(+) = rt.po_line_id
195: AND pha.po_header_id(+) = rt.po_header_id
238: , mtl_unit_transactions mut
239: -- , po_distributions_all pod --Commented as part of Bug# 3586116
240: , po_lines_all pol
241: , po_headers_all pha
242: , rcv_shipment_lines rsl
243: , wms_license_plate_numbers wlpn -- Bug 3836623
244: -- Bug 4179732, can not print serial number from putaway
245: -- Changed to link to MUT through MMT
246: , mtl_material_transactions mmt