DBA Data[Home] [Help]

APPS.WMS_WIP_XDOCK_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 949: l_mtl_lots_temp_rec mtl_transaction_lots_temp%ROWTYPE;

945: l_operation_seq_num NUMBER := NULL;
946: l_repetitive_schedule_id NUMBER := NULL;
947: l_primary_quantity NUMBER := 0;
948: l_transaction_quantity NUMBER := 0;
949: l_mtl_lots_temp_rec mtl_transaction_lots_temp%ROWTYPE;
950: l_mtl_srl_temp_rec mtl_serial_numbers_temp%ROWTYPE;
951: l_returnstatus VARCHAR2(1);
952: l_lpn_id NUMBER := NULL;
953: l_transfer_lpn_id NUMBER := NULL;

Line 1396: SUBTYPE mtlt_type IS mtl_transaction_lots_temp%ROWTYPE;

1392: SUBTYPE mmtt_type IS mtl_material_transactions_temp%ROWTYPE;
1393:
1394: mmtt_row mmtt_type;
1395:
1396: SUBTYPE mtlt_type IS mtl_transaction_lots_temp%ROWTYPE;
1397:
1398: lot_row mtlt_type;
1399:
1400: SUBTYPE msnt_type IS mtl_serial_numbers_temp%ROWTYPE;

Line 1412: FROM mtl_transaction_lots_temp

1408: v_allocate_serial_flag VARCHAR2(1) := 'X';
1409:
1410: CURSOR mtlt(txn_tmp_id NUMBER) IS
1411: SELECT *
1412: FROM mtl_transaction_lots_temp
1413: WHERE transaction_temp_id = txn_tmp_id;
1414:
1415: CURSOR msnt(txn_tmp_id NUMBER) IS
1416: SELECT *