[Home] [Help]
169: M.last_updated_by -- 6276012 added
170: --QZENG Bug 13881118 Changed from MTL_SYSTEM_ITEMS_B_KFV to MTL_SYSTEM_ITEMS_VL to support NLS
171: --FROM MTL_SYSTEM_ITEMS_B_KFV B,
172: FROM MTL_SYSTEM_ITEMS_VL B,
173: MTL_MATERIAL_TRANSACTIONS M,
174: MTL_TRANSACTION_TYPES T,
175: mtl_parameters mp
176: WHERE M.transaction_id = l_trans_id -- replace l_event_key by l_trans_id -- 9756188
177: AND M.organization_id = B.organization_id
182: -- Bug 4440045: added the inv_lot cursor
183: CURSOR inv_lot IS
184: SELECT c.PARENT_LOT_NUMBER, c.LOT_NUMBER
185: FROM MTL_LOT_NUMBERS C,
186: MTL_MATERIAL_TRANSACTIONS M,
187: MTL_TRANSACTION_LOT_NUMBERS L
188: WHERE M.transaction_id = l_trans_id -- replace l_event_key by l_trans_id -- 9756188
189: AND M.inventory_item_id = C.inventory_item_id
190: AND M.organization_id = C.organization_id
351: and mln.organization_id = mtln.organization_id;
352:
353: CURSOR rcv_transaction_id IS -- 13686877 new cursor
354: SELECT rcv_transaction_id
355: FROM mtl_material_transactions
356: WHERE transaction_id = l_trans_id;
357:
358:
359: CURSOR recv_inv(p_trans_id NUMBER, p_lot_number VARCHAR2) IS
786:
787: gmd_debug.put_line('recv_inv%notfound so trying cursor recv_no_lot for non-lot-controlled item ');
788:
789: -- 13686877
790: -- right now l_trans_id refers to mtl_material_transactions so we need to locate rcv_transaction_id in order to use as key to cursor recv_no_lot;
791:
792: OPEN rcv_transaction_id;
793: FETCH rcv_transaction_id
794: INTO l_rcv_transaction_id;