DBA Data[Home] [Help]

APPS.CSE_PO_RECEIPT_INTO_PROJECT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 78: DELETE FROM mtl_transaction_lots_temp

74:
75: DELETE FROM mtl_serial_numbers_temp
76: WHERE transaction_temp_id = l_interface_transaction_id;
77:
78: DELETE FROM mtl_transaction_lots_temp
79: WHERE transaction_temp_id = l_interface_transaction_id;
80:
81: END cleanup_transaction_temps;
82:

Line 592: FROM mtl_transaction_lots_temp mtlt,

588: CURSOR lotsrl_cur(p_interface_transaction_id in number, p_quantity in number) IS
589: SELECT mtlt.lot_number lot_number,
590: msn.serial_number serial_number,
591: decode(mtlt.serial_transaction_temp_id,null,nvl(mtlt.transaction_quantity,p_quantity),1) quantity
592: FROM mtl_transaction_lots_temp mtlt,
593: mtl_serial_numbers msn
594: WHERE mtlt.transaction_temp_id = p_interface_transaction_id
595: AND msn.line_mark_id(+) = mtlt.serial_transaction_temp_id;
596: