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 779: from MTL_TRANSACTION_LOT_NUMBERS

775: ATTRIBUTE13 ,
776: ATTRIBUTE14 ,
777: ATTRIBUTE15 --,
778: --PARENT_LOT_NUMBER
779: from MTL_TRANSACTION_LOT_NUMBERS
780: --Bug 5614015:Rowid is used to uniquely identify the lot selected
781: --where transaction_id = l_mmt_rec.transaction_id
782: --and lot_number = l_lot_txn_rec.lot_number;
783: where rowid = l_lot_txn_rec.rowid;