[Home] [Help]
261: rt.vendor_lot_num, --Bug#6145310
262: rt.MOBILE_TXN, -- 9509656
263: rt.TRANSACTION_ID, -- 9509656
264: rt.last_updated_by --Bug#6276012 added
265: FROM rcv_transactions rt,
266: mtl_system_items_kfv im,
267: mtl_parameters so,
268: rcv_shipment_lines sl,
269: po_headers_all po,
312: hou.name, --RLNAGARA B5018797
313: rt.vendor_lot_num, --Bug#6145310
314: rt.MOBILE_TXN, -- 9509656
315: rt.TRANSACTION_ID -- 9509656
316: FROM rcv_transactions rt,
317: mtl_system_items_kfv im,
318: mtl_parameters so,
319: rcv_shipment_lines sl,
320: po_headers_all po,
385: sum(tran.secondary_quantity) lot_secondary,
386: rt.vendor_lot_num ,--Bug#6145310
387: lot.grade_code, -- 10044459
388: tran.last_updated_by --Bug#6276012 added
389: FROM rcv_transactions rt,
390: --QZENG Bug 13881118 Change view from mtl_system_items_b_kfv to mtl_system_items_vl to support NLS
391: --mtl_system_items_b_kfv im,
392: mtl_system_items_vl im,
393: mtl_parameters so,
513: from wf_Resources
514: where name = 'WF_ADMIN_ROLE' --RLNAGARA B5654562 Changed from WF_ADMIN to WF_ADMIN_ROLE
515: and language = userenv('LANG');
516:
517: -- Bug 4165704 - org_id should be in rcv_transactions table, but since it isn't
518: -- I need to get the value here
519: --RLNAGARA B5018797 org_id is there in the po_headers_all table and hence getting from there.
520: -- Here we are getting vendor name instead of vendor_site_code.
521: CURSOR get_vendor_no IS /* 4576699*/
698: gmd_debug.put_line('PO Receipts'); -- Bug # 4576699
699:
700: l_transaction_type := 'RECEIVING_TRANSACTION';
701: --wf_log_pkg.string(6, 'Dummy','PO Receipts');
702: /* Set Org Context as we are using multi org view RCV_TRANSACTIONS_V */
703:
704: OPEN recv;
705: FETCH recv
706: INTO l_organization_code, l_organization_id, l_subinventory, l_inventory_item_id,