DBA Data[Home] [Help]

APPS.PJM_UEFF_ONHAND dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 219: FROM mtl_transaction_lots_temp

215: WHERE msnt.transaction_temp_id in (
216: SELECT X_trx_temp_id FROM dual
217: UNION ALL
218: SELECT serial_transaction_temp_id
219: FROM mtl_transaction_lots_temp
220: WHERE transaction_temp_id = X_trx_temp_id )
221: AND rownum = 1;
222:
223: if ( L_trx_qty = 0 ) then

Line 245: FROM mtl_transaction_lots_temp

241: WHERE msnt.transaction_temp_id in (
242: SELECT X_trx_temp_id FROM dual
243: UNION ALL
244: SELECT serial_transaction_temp_id
245: FROM mtl_transaction_lots_temp
246: WHERE transaction_temp_id = X_trx_temp_id )
247: AND msn.serial_number >= msnt.fm_serial_number
248: AND msn.serial_number <= nvl(msnt.to_serial_number , msnt.fm_serial_number)
249: AND length(msn.serial_number) = length(msnt.fm_serial_number)