DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_GRP dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 257: from mtl_transaction_lot_numbers MTLN

253: SELECT TRANSACTION_ID,
254: SERIAL_TRANSACTION_ID,
255: LOT_NUMBER,
256: ROWID
257: from mtl_transaction_lot_numbers MTLN
258: where MTLN.organization_id = p_organization_id
259: and MTLN.transaction_id = v_txn_id;
260:
261: l_open_past_period BOOLEAN := false;

Line 785: from MTL_TRANSACTION_LOT_NUMBERS

781: ATTRIBUTE13 ,
782: ATTRIBUTE14 ,
783: ATTRIBUTE15 --,
784: --PARENT_LOT_NUMBER
785: from MTL_TRANSACTION_LOT_NUMBERS
786: --Bug 5614015:Rowid is used to uniquely identify the lot selected
787: --where transaction_id = l_mmt_rec.transaction_id
788: --and lot_number = l_lot_txn_rec.lot_number;
789: where rowid = l_lot_txn_rec.rowid;