APPS.WMS_WIP_XDOCK_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 950: l_mtl_srl_temp_rec mtl_serial_numbers_temp%ROWTYPE;

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;
954: l_content_lpn_id NUMBER := NULL;

Line 959: FROM mtl_serial_numbers_temp

955: l_bflow_exist NUMBER;
956:
957: CURSOR serial_csr IS
958: SELECT fm_serial_number
959: FROM mtl_serial_numbers_temp
960: WHERE transaction_temp_id = l_serial_temp_id;
961:
962: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
963: BEGIN

Line 1400: SUBTYPE msnt_type IS mtl_serial_numbers_temp%ROWTYPE;

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;
1401:
1402: ser_row msnt_type;
1403: l_new_txn_hdr_id NUMBER := -1;
1404: new_txn_temp_id NUMBER := -1;

Line 1417: FROM mtl_serial_numbers_temp

1413: WHERE transaction_temp_id = txn_tmp_id;
1414:
1415: CURSOR msnt(txn_tmp_id NUMBER) IS
1416: SELECT *
1417: FROM mtl_serial_numbers_temp
1418: WHERE transaction_temp_id = txn_tmp_id;
1419:
1420: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1421: BEGIN