APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 103: (SELECT lot_number FROM mtl_transaction_lots_temp

99: IF (l_lot_code >1) THEN--means LOT CONTROLLED
100:
101: IF l_child_rec.lot_number IS NOT NULL THEN
102: SELECT 1 INTO l_lot_cnt FROM dual WHERE exists
103: (SELECT lot_number FROM mtl_transaction_lots_temp
104: WHERE transaction_temp_id = p_txn_temp_id
105: AND lot_number = l_child_rec.lot_number );
106:
107: IF l_lot_cnt = 1 then

Line 109: FROM mtl_transaction_lots_temp

105: AND lot_number = l_child_rec.lot_number );
106:
107: IF l_lot_cnt = 1 then
108: SELECT TRANSACTION_QUANTITY INTO l_orig_lot_qty
109: FROM mtl_transaction_lots_temp
110: WHERE transaction_temp_id = p_txn_temp_id
111: AND lot_number = l_child_rec.lot_number;
112: END IF;
113: --make sure that lot_qty is not more than the allocated for

Line 139: mtl_transaction_lots_temp mtlt

135: IF l_child_rec.serial_number IS NOT NULL THEN
136: SELECT 1 INTO l_serial_cnt FROM dual WHERE exists
137: (SELECT fm_serial_number--What if RANGE serials ??
138: FROM mtl_serial_numbers_temp msnt,
139: mtl_transaction_lots_temp mtlt
140: WHERE mtlt.transaction_temp_id = p_txn_temp_id
141: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
142: AND msnt.fm_serial_number = l_child_rec.serial_number);
143:

Line 1084: mtl_transaction_lots_temp mtlt

1080: SELECT
1081: mtlt.primary_quantity,
1082: mtlt.lot_number
1083: FROM
1084: mtl_transaction_lots_temp mtlt
1085: WHERE mtlt.transaction_temp_id = p_temp_id;
1086:
1087: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1088: BEGIN

Line 1363: mtl_transaction_lots_temp mtlt

1359:
1360: SELECT 1 INTO l_item_cnt FROM DUAL WHERE exists
1361: ( SELECT 1
1362: FROM wms_lpn_contents wlc,
1363: mtl_transaction_lots_temp mtlt
1364: WHERE wlc.parent_lpn_id = p_lpn
1365: AND wlc.organization_id = p_org_id
1366: AND wlc.inventory_item_id = p_item_id
1367: AND Nvl(wlc.revision,'-999') = Nvl(p_rev,Nvl(wlc.revision,'-999'))

Line 1800: mtl_transaction_lots_temp mtlt

1796:
1797: SELECT COUNT(fm_serial_number)
1798: INTO l_total_serial_cnt
1799: FROM mtl_serial_numbers_temp msnt,
1800: mtl_transaction_lots_temp mtlt
1801: WHERE mtlt.transaction_temp_id = p_temp_id
1802: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
1803:
1804: IF (l_debug = 1) THEN

Line 2084: mtl_transaction_lots_temp mtlt

2080: SELECT COUNT(fm_serial_number)
2081: INTO l_serial_exist_cnt
2082: FROM
2083: mtl_serial_numbers_temp msnt,
2084: mtl_transaction_lots_temp mtlt
2085: WHERE mtlt.transaction_temp_id = p_temp_id
2086: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
2087: AND msnt.fm_serial_number IN
2088: ( SELECT serial_number

Line 2475: mtl_transaction_lots_temp mtlt

2471:
2472: SELECT COUNT(fm_serial_number)
2473: INTO l_total_serial_cnt
2474: FROM mtl_serial_numbers_temp msnt,
2475: mtl_transaction_lots_temp mtlt
2476: WHERE mtlt.transaction_temp_id = p_temp_id
2477: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
2478:
2479: IF (l_debug = 1) THEN

Line 3105: mtl_transaction_lots_temp mtlt

3101: msnt.fm_serial_number,
3102: msnt.to_serial_number
3103: FROM
3104: mtl_serial_numbers_temp msnt,
3105: mtl_transaction_lots_temp mtlt
3106: WHERE mtlt.transaction_temp_id = l_txn_temp_id
3107: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
3108: */
3109:

Line 4056: FROM mtl_transaction_lots_temp mtlt

4052:
4053: DELETE FROM mtl_serial_numbers_temp msnt
4054: WHERE msnt.transaction_temp_id IN
4055: (SELECT mtlt.serial_transaction_temp_id
4056: FROM mtl_transaction_lots_temp mtlt
4057: WHERE mtlt.transaction_temp_id = l_txn_temp_id);
4058: END IF;
4059:
4060: DELETE FROM mtl_transaction_lots_temp mtlt

Line 4060: DELETE FROM mtl_transaction_lots_temp mtlt

4056: FROM mtl_transaction_lots_temp mtlt
4057: WHERE mtlt.transaction_temp_id = l_txn_temp_id);
4058: END IF;
4059:
4060: DELETE FROM mtl_transaction_lots_temp mtlt
4061: WHERE mtlt.transaction_temp_id = l_txn_temp_id;
4062:
4063: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN --Serial controlled item
4064:

Line 4138: FROM mtl_transaction_lots_temp mtlt

4134: IF (l_serial_code >1 AND l_serial_code<>6) THEN -- Lot and Serial controlled item
4135: DELETE FROM mtl_serial_numbers_temp msnt
4136: WHERE msnt.transaction_temp_id IN
4137: (SELECT mtlt.serial_transaction_temp_id
4138: FROM mtl_transaction_lots_temp mtlt
4139: WHERE mtlt.transaction_temp_id = l_txn_temp_id);
4140: END IF;
4141:
4142: DELETE FROM mtl_transaction_lots_temp mtlt

Line 4142: DELETE FROM mtl_transaction_lots_temp mtlt

4138: FROM mtl_transaction_lots_temp mtlt
4139: WHERE mtlt.transaction_temp_id = l_txn_temp_id);
4140: END IF;
4141:
4142: DELETE FROM mtl_transaction_lots_temp mtlt
4143: WHERE mtlt.transaction_temp_id = l_txn_temp_id;
4144:
4145: ELSIF (l_serial_code >1 AND l_serial_code<>6) THEN --Serial controlled item
4146:

Line 4214: FROM mtl_transaction_lots_temp mtlt,

4210:
4211: DELETE FROM mtl_serial_numbers_temp msnt
4212: WHERE transaction_temp_id IN
4213: (SELECT msnt.transaction_temp_id
4214: FROM mtl_transaction_lots_temp mtlt,
4215: mtl_serial_numbers_temp msnt
4216: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
4217: AND mtlt.transaction_temp_id =l_txn_temp_id)
4218: AND msnt.fm_serial_number NOT IN

Line 4254: update mtl_transaction_lots_temp set

4250: END IF;
4251:
4252: trace('l_mtlt_pr_qty::'||l_mtlt_pr_qty||'mtlt_lot_TXN_QTY:::'||l_mtlt_update.lot_qty);
4253:
4254: update mtl_transaction_lots_temp set
4255: TRANSACTION_QUANTITY = l_mtlt_update.lot_qty,
4256: PRIMARY_QUANTITY = l_mtlt_pr_qty
4257: WHERE transaction_temp_id = l_txn_temp_id
4258: AND lot_number = l_mtlt_update.lot_number;

Line 4263: DELETE FROM mtl_transaction_lots_temp mtlt

4259:
4260: end loop;
4261:
4262: /*9908576-It is possible that some lots are totally missing. Let's delete them from MTLT*/
4263: DELETE FROM mtl_transaction_lots_temp mtlt
4264: WHERE mtlt.transaction_temp_id = l_txn_temp_id
4265: AND NOT EXISTS (
4266: SELECT 1 FROM wms_device_requests wdr
4267: WHERE wdr.relation_id = l_rec.relation_id