[Home] [Help]
328: p_org_id NUMBER)
329: IS
330: CURSOR loaded_lpn_cur IS
331: SELECT wlpn.lpn_id,NVL(wlpn.parent_lpn_id,0),NVL(mmtt.lpn_id,0),NVL(mmtt.content_lpn_id,0),mmtt.transaction_temp_id
332: FROM mtl_material_transactions_temp mmtt ,
333: wms_license_plate_numbers wlpn
334: WHERE wlpn.organization_id = p_org_id
335: AND wlpn.outermost_lpn_id = p_lpn_id
336: AND wlpn.outermost_lpn_id <> wlpn.lpn_id
360: debug('Updating MMTT : temp_id '||l_temp_id);
361: END IF;
362:
363: IF ( l_mmtt_lpn_id > 0 AND l_mmtt_cont_lpn_id > 0 AND l_mmtt_lpn_id <> l_mmtt_cont_lpn_id ) THEN
364: UPDATE mtl_material_transactions_temp mmtt
365: SET mmtt.lpn_id=null
366: WHERE mmtt.transaction_temp_id = l_temp_id
367: AND mmtt.lpn_id = l_par_lpn_id
368: AND mmtt.content_lpn_id = l_lpn_id;
675: mtrl.txn_source_id,
676: mmtt.primary_quantity,
677: mmtt.secondary_transaction_quantity, -- 9037915
678: mmtt.secondary_uom_code -- 9037915
679: FROM mtl_material_transactions_temp mmtt
680: ,mtl_txn_request_lines mtrl
681: ,wms_dispatched_tasks wdt
682: --,mtl_item_locations milk
683: ,mtl_system_items_kfv msik
1055: l_progress := '330';
1056:
1057:
1058: FORALL i IN 1 ..l_txn_temp_id_tab.COUNT
1059: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
1060: SET transaction_header_id = l_txn_header_id
1061: WHERE transaction_temp_id = l_txn_temp_id_tab(i);
1062:
1063: l_progress := '340';
1178: l_progress := '160';
1179:
1180:
1181: FORALL i IN 1 ..l_txn_temp_id_tab.COUNT
1182: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
1183: SET transaction_header_id = l_txn_header_id
1184: WHERE transaction_temp_id = l_txn_temp_id_tab(i);
1185: l_progress := '170';
1186:
2566: SELECT COUNT(DISTINCT NVL(transfer_to_location,locator_id))
2567: ,COUNT(DISTINCT cartonization_id)
2568: INTO l_loc_count
2569: ,l_to_lpn_count
2570: FROM mtl_material_transactions_temp mmtt
2571: ,mtl_txn_request_lines mtrl
2572: WHERE mmtt.move_order_line_id = mtrl.line_id
2573: AND mtrl.lpn_id = l_lpn_id_tab(i);
2574: l_progress := '150';
2664: AND mtrl.lpn_id = l_lpn_id_tab(i)
2665: AND mtrl.line_status = 7 --BUG 3352572
2666: AND ((NOT exists
2667: (SELECT 1
2668: FROM mtl_material_transactions_temp mmtt1
2669: WHERE mtrl.line_status = 7
2670: AND mmtt1.move_order_line_id = mtrl.line_id)
2671: ) OR
2672: (( (NVL(quantity,0) - NVL(quantity_delivered,0) ) )
2670: AND mmtt1.move_order_line_id = mtrl.line_id)
2671: ) OR
2672: (( (NVL(quantity,0) - NVL(quantity_delivered,0) ) )
2673: > (SELECT SUM(transaction_quantity)
2674: FROM mtl_material_transactions_temp mmtt
2675: WHERE mtrl.line_status = 7
2676: AND mmtt.move_order_line_id = mtrl.line_id
2677: ))
2678: )
2963:
2964:
2965: --R12: Revert MDC suggestions for all tasks that is flagged as item drop
2966: BEGIN
2967: UPDATE mtl_material_transactions_temp
2968: SET cartonization_id = NULL
2969: WHERE transaction_temp_id IN (SELECT gtmp.transaction_temp_id
2970: FROM wms_putaway_group_tasks_gtmp gtmp
2971: WHERE gtmp.consolidation_method_id = 1 --???MDC
3130: START WITH LPN_ID IN (
3131: SELECT DISTINCT wln2.outermost_lpn_id
3132: FROM wms_dispatched_tasks wdt
3133: ,mtl_txn_request_lines mtrl
3134: ,mtl_material_transactions_temp mmtt
3135: ,mtl_txn_request_headers mtrh
3136: ,wms_license_plate_numbers wln2
3137: WHERE mtrh.header_id = mtrl.header_id
3138: AND mtrh.move_order_type = 6
3402: Decode(wln.locator_id,NVL(mmtt.transfer_to_location, mmtt.locator_id),1,0) show_message,
3403: mmtt.error_code,
3404: mmtt.error_explanation
3405: --R12 End
3406: FROM mtl_material_transactions_temp mmtt
3407: ,mtl_txn_request_lines mtrl
3408: ,wms_dispatched_tasks wdt
3409: --,mtl_item_locations milk
3410: ,mtl_system_items_kfv msik
3840: START WITH lpn_id = p_lpn_id
3841: CONNECT BY PRIOR lpn_id = parent_lpn_id
3842: ) wlpn,
3843: mtl_txn_request_lines mtrl,
3844: mtl_material_transactions_temp mmtt
3845: WHERE mtrl.line_id = mmtt.move_order_line_id
3846: AND mtrl.line_status = 7
3847: AND mtrl.lpn_id = wlpn.lpn_id ;
3848:
4025: START WITH lpn_id = p_lpn_id
4026: CONNECT BY PRIOR lpn_id = parent_lpn_id
4027: ) wlpn,
4028: mtl_txn_request_lines mtrl,
4029: mtl_material_transactions_temp mmtt
4030: WHERE mtrl.line_id = mmtt.move_order_line_id
4031: AND mtrl.line_status = 7
4032: AND mtrl.lpn_id = wlpn.lpn_id ;
4033:
4364: ,wlpn.license_plate_number into_lpn_name
4365: ,msi.dropping_order sub_dropping_order
4366: ,milk.dropping_order loc_dropping_order
4367: ,Nvl(msi.lpn_controlled_flag,2) lpn_controlled_flag
4368: FROM mtl_material_transactions_temp mmtt
4369: ,wms_license_plate_numbers wlpn
4370: ,mtl_secondary_inventories msi
4371: ,mtl_item_locations_kfv milk
4372: WHERE mmtt.transaction_temp_id = v_transaction_temp_id
5298: FROM
5299: ( SELECT LPN_ID
5300: FROM WMS_LICENSE_PLATE_NUMBERS START WITH LPN_ID = p_lpn_id CONNECT BY PRIOR LPN_ID = PARENT_LPN_ID ) WLPN,
5301: MTL_TXN_REQUEST_LINES MTRL,
5302: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
5303: WHERE MTRL.LINE_ID = MMTT.MOVE_ORDER_LINE_ID
5304: AND LINE_STATUS = 7
5305: AND MTRL.LPN_ID = WLPN.LPN_ID ;
5306:
5542:
5543: -- This cursor will get the MMTTs assoicated with the move order line passed
5544: CURSOR c_mol_mmtt_cursor IS
5545: SELECT mmtt.transaction_temp_id
5546: FROM mtl_material_transactions_temp mmtt
5547: ,mtl_txn_request_lines mtrl
5548: WHERE mtrl.line_id = mmtt.move_order_line_id
5549: AND mtrl.line_id = p_mo_line_id
5550: AND mtrl.line_status = 7
5786: -- This cursor will get the all the MMTTs assoicated with the lpn_id passed.
5787: -- Cleanup shouldn't be called if there is not WDT and hence added a join with WDT.
5788: CURSOR c_mol_mmtt_cursor IS
5789: SELECT mmtt.transaction_temp_id
5790: FROM mtl_material_transactions_temp mmtt
5791: ,mtl_txn_request_lines mtrl
5792: ,wms_dispatched_tasks wdt
5793: ,(SELECT lpn_id FROM wms_license_plate_numbers /*Bug5723418.*/
5794: START WITH lpn_id = p_lpn_id
5823: CURSOR c_all_mmtt_cursor IS
5824: SELECT mmtt.transaction_temp_id
5825: FROM wms_dispatched_tasks wdt
5826: ,mtl_txn_request_lines mtrl
5827: ,mtl_material_transactions_temp mmtt
5828: ,mtl_txn_request_headers mtrh
5829: WHERE mtrh.header_id = mtrl.header_id
5830: AND mtrh.move_order_type = 6
5831: AND mtrl.line_status = 7
5856: UNION ALL
5857: SELECT mmtt.transaction_temp_id
5858: FROM wms_dispatched_tasks wdt
5859: ,mtl_txn_request_lines mtrl
5860: ,mtl_material_transactions_temp mmtt
5861: ,mtl_txn_request_headers mtrh
5862: WHERE mtrh.header_id = mtrl.header_id
5863: AND mtrh.move_order_type = 6
5864: AND mtrl.line_status = 7
6092: , l_mol_id
6093: , l_mmtt_item_id
6094: , l_mol_uom
6095: , l_wms_process_flag
6096: FROM mtl_material_transactions_temp mmtt
6097: , mtl_txn_request_lines mtrl
6098: WHERE mmtt.transaction_temp_id = l_tempid_tab(i)
6099: AND mmtt.move_order_line_id = mtrl.line_id;
6100: EXCEPTION
6202: END IF;
6203:
6204: BEGIN
6205: --delete MMTT
6206: DELETE FROM mtl_material_transactions_temp
6207: WHERE transaction_temp_id = l_tempid_tab(i);
6208: EXCEPTION
6209: WHEN OTHERS THEN
6210: IF (l_debug = 1) THEN
6312: BEGIN
6313: UPDATE mtl_txn_request_lines
6314: SET wms_process_flag = 1
6315: WHERE line_id IN (SELECT move_order_line_id
6316: FROM mtl_material_transactions_temp
6317: WHERE transaction_temp_id = l_tempid_tab(i))
6318: AND wms_process_flag = 2;
6319: EXCEPTION
6320: WHEN OTHERS THEN
6561: , wooi.last_updated_by
6562: INTO l_drop_active
6563: , l_userid
6564: FROM mtl_txn_request_lines mtrl,
6565: mtl_material_transactions_temp mmtt,
6566: wms_op_operation_instances wooi ,
6567: (SELECT wlpn.lpn_id /*5723418*/
6568: FROM wms_license_plate_numbers wlpn
6569: START WITH wlpn.lpn_id = p_lpn_id
6649: BEGIN
6650: SELECT 'Y' INTO x_loaded_status FROM dual where exists
6651: (SELECT 1 from
6652: wms_dispatched_tasks W,
6653: mtl_material_transactions_temp t,
6654: mtl_txn_request_lines M
6655: WHERE m.lpn_id = p_lpn_id
6656: AND m.organization_id = p_org_id
6657: AND m.line_status <> 5
6675: GROUP BY inventory_item_id,organization_id) LOOP
6676: l_mmtt_qty := 0;
6677: SELECT Sum(mmtt.primary_quantity) INTO l_mmtt_qty
6678: FROM wms_dispatched_tasks W,
6679: mtl_material_transactions_temp mmtt,
6680: mtl_txn_request_lines M
6681: WHERE m.lpn_id = p_lpn_id
6682: AND m.organization_id = x.organization_id
6683: AND m.line_status <> 5
6708: begin
6709: if (x_lpn_context =1 and x_loaded_status = 'N' ) then
6710: -- SELECT 'Y' INTO x_loaded_status FROM dual where exists
6711: SELECT 'Z' INTO x_loaded_status FROM dual where exists -- End of changes for the bug 5768339.
6712: (SELECT 1 FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
6713: WHERE mmtt.transaction_temp_id = wdt.transaction_temp_id
6714: AND mmtt.organization_id = wdt.organization_id
6715: AND wdt.status = 4
6716: AND wdt.organization_id = p_org_id
6772:
6773: --Bug#6920388.Added IF block below.
6774: BEGIN
6775: SELECT COUNT(1) INTO l_invalid_cnt
6776: FROM Mtl_material_transactions_temp mmtt,
6777: Wms_License_Plate_Numbers wlpn
6778: WHERE mmtt.organization_id=p_org_id
6779: AND mmtt.wms_task_type <> WMS_GLOBALS.g_wms_task_type_putaway
6780: AND wlpn.outermost_lpn_id = p_lpn_id
6924: IF l_entire_lpn_empty THEN
6925: BEGIN
6926: SELECT 'Y' INTO x_loaded_status FROM dual where exists
6927: (select 1 from
6928: WMS_DISPATCHED_TASKS W, MTL_MATERIAL_TRANSACTIONS_TEMP T
6929: WHERE T.lpn_id = l_lpn_id
6930: AND t.organization_id = p_org_id
6931: AND w.organization_id = p_org_id
6932: AND T.transaction_temp_id = W.transaction_temp_id
7145: CONNECT BY PRIOR lpn_id = parent_lpn_id ) wlpn ,
7146: wms_lpn_contents wlc
7147: where
7148: wlc.parent_lpn_id = wlpn.lpn_id
7149: and not exists (select 1 from mtl_material_transactions_temp mmtt
7150: where mmtt.organization_id = wlc.organization_id
7151: AND mmtt.inventory_item_id = wlc.inventory_item_id
7152: AND (mmtt.lpn_id = wlc.parent_lpn_id or mmtt.content_lpn_id = wlc.parent_lpn_id));
7153:
7313: END IF;
7314:
7315: -- Update batch id and seq id
7316: IF p_batch_id IS NOT NULL AND p_batch_seq IS NOT NULL THEN
7317: UPDATE mtl_material_transactions_temp
7318: SET transaction_header_id = p_trx_header_id
7319: , transaction_batch_id = p_batch_id
7320: , transaction_batch_seq = p_batch_seq
7321: WHERE transaction_temp_id = l_txn_temp_id;
7511: RAISE fnd_api.g_exc_error;
7512: END IF;
7513:
7514: BEGIN
7515: UPDATE mtl_material_transactions_temp
7516: SET transaction_header_id = l_trx_header_id
7517: , transaction_batch_id = l_trx_header_id
7518: , transaction_batch_seq = 2
7519: WHERE transaction_temp_id = l_txn_temp_id;
7816: --BUG 3359835: Must call activate_operation_instance
7817: l_progress := 40;
7818: SELECT mmtt.transaction_temp_id
7819: bulk collect INTO l_mmtt_ids
7820: FROM mtl_material_transactions_temp mmtt
7821: WHERE mmtt.organization_id = p_org_id
7822: AND mmtt.move_order_line_id IN
7823: ( SELECT mtrl.line_id
7824: FROM mtl_txn_request_lines mtrl ,
9034: SELECT
9035: mmtt.transaction_temp_id
9036: BULK COLLECT INTO
9037: l_txn_tmp_id_tb
9038: FROM mtl_material_transactions_temp mmtt
9039: WHERE -- suggestion mmtts?
9040: ( ( mmtt.transaction_source_type_id = 1 AND
9041: mmtt.transaction_action_id = 27) OR
9042: ( mmtt.transaction_source_type_id = 7 AND
9086: SELECT
9087: mmtt.transaction_temp_id
9088: BULK COLLECT INTO
9089: l_txn_tmp_id_tb
9090: FROM mtl_material_transactions_temp mmtt
9091: WHERE -- suggestion mmtts?
9092: mmtt.organization_id = l_org_id AND
9093: mmtt.move_order_line_id --BUG 3435079: use org_id for performace reason
9094: IN ( SELECT mtrl.line_id
9681: --BUG 3435079: The query doesn't seem to be picking up the lpn_id
9682: --index on MMTT. So replace it with the following, and also
9683: --Move it BEFORE updating MOL
9684: UPDATE
9685: mtl_material_transactions_temp
9686: SET
9687: lpn_id = p_into_lpn_id
9688: WHERE
9689: lpn_id = p_from_lpn_id;
9757: RAISE fnd_api.g_exc_error;
9758: END IF;
9759:
9760: BEGIN
9761: UPDATE mtl_material_transactions_temp
9762: SET transaction_header_id = l_hdr_id
9763: , transaction_batch_id = l_hdr_id
9764: , transaction_batch_seq = l_batch_seq
9765: WHERE transaction_temp_id = l_txn_tmp_id;
9828: RAISE fnd_api.g_exc_error;
9829: END IF;
9830:
9831: BEGIN
9832: UPDATE mtl_material_transactions_temp
9833: SET transaction_header_id = l_hdr_id
9834: , transaction_batch_id = l_hdr_id
9835: , transaction_batch_seq = l_batch_seq
9836: WHERE transaction_temp_id = l_txn_tmp_id;
9896: RAISE fnd_api.g_exc_error;
9897: END IF;
9898:
9899: BEGIN
9900: UPDATE mtl_material_transactions_temp
9901: SET transaction_header_id = l_hdr_id
9902: , transaction_batch_id = l_hdr_id
9903: , transaction_batch_seq = l_batch_seq
9904: WHERE transaction_temp_id = l_txn_tmp_id;
10028: --BUG 3435079: The query doesn't seem to be picking up the lpn_id
10029: --index on MMTT. So replace it with the following, and also
10030: --Move it BEFORE updating MOL
10031: UPDATE
10032: mtl_material_transactions_temp
10033: SET
10034: lpn_id = p_into_lpn_id
10035: WHERE
10036: lpn_id = p_from_lpn_id;
10268: , mmtt.secondary_transaction_quantity --OPM Convergence
10269: , mmtt.secondary_uom_code -- 9037915
10270: , mtrl.inspection_status
10271: , msi.primary_uom_code
10272: FROM mtl_material_transactions_temp mmtt
10273: , mtl_txn_request_lines mtrl
10274: , mtl_txn_request_headers mtrh
10275: , mtl_system_items_kfv msi
10276: , ( /*5723418*/
10945: SELECT SUM(mmtt.primary_quantity),
10946: SUM(mmtt.secondary_transaction_quantity) -- 9037915
10947: INTO l_prim_qty_consumable,
10948: l_sec_qty_consumable
10949: FROM mtl_material_transactions_temp mmtt
10950: , mtl_txn_request_lines mtrl
10951: WHERE mmtt.transaction_header_id = p_txn_header_id
10952: AND mtrl.line_id = l_mol_line_id
10953: AND mtrl.line_id = mmtt.move_order_line_id;
11724: --If there is only one MMTT for the current mol, then p_entire_flag
11725: --should be 'N' else it should be 'Y'
11726: SELECT count(1)
11727: INTO l_mmtt_count
11728: FROM mtl_material_transactions_temp
11729: WHERE move_order_line_id = l_mol_line_id_tbl(i);
11730:
11731: IF l_mmtt_count > 1 THEN
11732: l_entire_lpn := 'N';
11787:
11788: --For INV/WIP LPNs, we would be calling the Inventory TM for the current
11789: --group. So, should update the MMTT with the new txn_header_id
11790: IF (p_lpn_context <> G_LPN_CONTEXT_RCV) THEN
11791: UPDATE mtl_material_transactions_temp
11792: SET transaction_header_id = l_new_txn_header_id
11793: , transaction_batch_id = l_new_txn_header_id
11794: , transaction_batch_seq = l_batch_seq --BUG 3306988
11795: WHERE transaction_temp_id = l_mmtt_temp_id;
11922: END IF;
11923:
11924:
11925: SELECT count(DISTINCT operation_plan_id) INTO l_lms_rec_count
11926: FROM mtl_material_transactions_temp mmtt
11927: WHERE transaction_header_id = p_txn_header_id;
11928:
11929: IF (l_debug = 1) THEN
11930: debug('complete_putaway_wrapper: LMS Code, l_lms_rec_count: ' || l_lms_rec_count , l_proc_name);
11933: IF l_lms_rec_count = 1 THEN
11934: -- since same OperationPlanId stamped for all the MMTTs of the group
11935: -- return its value for LMS data capture
11936: SELECT operation_plan_id INTO x_lms_operation_plan_id
11937: FROM mtl_material_transactions_temp
11938: WHERE transaction_header_id = p_txn_header_id
11939: AND ROWNUM = 1;
11940:
11941: IF (l_debug = 1) THEN
12509: So, modified mmmt.lpn_id to mtrl.lpn_id and introduced join
12510: with mmmt and mtrl table.
12511: */
12512: (EXISTS (SELECT 'LOADED_BY_SAME_USER'
12513: FROM mtl_material_transactions_temp mmtt,
12514: wms_dispatched_tasks wdt,--5650113
12515: mtl_txn_request_lines mtrl--5650113
12516: WHERE mmtt.organization_id = p_organization_id
12517: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
12723: SELECT MAX(mtrl.backorder_delivery_detail_id)
12724: INTO l_bo_d_to_id
12725: FROM mtl_txn_request_lines mtrl
12726: WHERE EXISTS (SELECT 1
12727: FROM rcv_transactions_interface rti, mtl_material_transactions_temp mmtt
12728: WHERE rti.transfer_lpn_id = l_into_lpn_id
12729: AND rti.mmtt_temp_id = mmtt.transaction_temp_id
12730: AND mmtt.move_order_line_id = mtrl.line_id
12731: AND mmtt.inventory_item_id = mtrl.inventory_item_id
12874: ((wlpn.lpn_context = 1 AND l_lpn_context IN (1,2) ) OR
12875: wlpn.lpn_context IN (1,3,11) AND l_lpn_context = 3)--BUG 3463634 --BUG#11769042(Adding LPN context 11)
12876: AND (p_lpn_id = wlpn.lpn_id OR --BUG 3368408
12877: (NOT EXISTS (SELECT 'LOADED'
12878: FROM mtl_material_transactions_temp mmtt,
12879: wms_dispatched_tasks wdt
12880: WHERE mmtt.organization_id = p_organization_id
12881: AND mmtt.transaction_temp_id = wdt.transaction_temp_id
12882: AND wdt.organization_id = p_organization_id
13314: CONNECT BY PRIOR lpn_id = parent_lpn_id
13315: )
13316: wlpn,
13317: mtl_txn_request_lines mtrl,
13318: mtl_material_transactions_temp mmtt
13319: WHERE
13320: (
13321: mtrl.line_id = mmtt.move_order_line_id
13322: )
13335: START WITH lpn_id = p_lpn_id
13336: CONNECT BY PRIOR lpn_id = parent_lpn_id
13337: )
13338: wlpn,
13339: mtl_material_transactions_temp mmtt
13340: WHERE
13341: (
13342: wlpn.lpn_id = mmtt.lpn_id
13343: OR wlpn.lpn_id = mmtt.content_lpn_id
13763: (
13764: SELECT
13765: parent_line_id
13766: FROM
13767: mtl_material_transactions_temp
13768: WHERE
13769: move_order_line_id IN
13770: (
13771: SELECT
13796: (
13797: SELECT
13798: transaction_temp_id
13799: FROM
13800: mtl_material_transactions_temp
13801: WHERE
13802: move_order_line_id IN
13803: (
13804: SELECT
13829: (
13830: SELECT
13831: transaction_temp_id
13832: FROM
13833: mtl_material_transactions_temp
13834: WHERE
13835: move_order_line_id IN
13836: (
13837: SELECT
13855: );
13856: --delete MMTT
13857: DELETE
13858: FROM
13859: mtl_material_transactions_temp
13860: WHERE
13861: transaction_temp_id IN
13862: (
13863: SELECT
13862: (
13863: SELECT
13864: parent_line_id
13865: FROM
13866: mtl_material_transactions_temp
13867: WHERE
13868: move_order_line_id IN
13869: (
13870: SELECT
13927:
13928: SELECT
13929: transaction_temp_id
13930: FROM
13931: mtl_material_transactions_temp
13932: WHERE
13933: move_order_line_id IN
13934: (
13935: SELECT
13971:
13972: SELECT
13973: transaction_temp_id
13974: FROM
13975: mtl_material_transactions_temp
13976: WHERE
13977: move_order_line_id IN
13978: (
13979: SELECT
14037:
14038: SELECT
14039: transaction_temp_id
14040: FROM
14041: mtl_material_transactions_temp
14042: WHERE
14043: move_order_line_id IN
14044: (
14045: SELECT
14064:
14065: --delete MMTT
14066: DELETE
14067: FROM
14068: mtl_material_transactions_temp
14069: WHERE
14070: transaction_temp_id IN
14071: (
14072: SELECT
14071: (
14072: SELECT
14073: transaction_temp_id
14074: FROM
14075: mtl_material_transactions_temp
14076: WHERE
14077: move_order_line_id IN
14078: (
14079: SELECT
14271: l_crossdock_types,
14272: l_wip_supply_types
14273: FROM
14274: mtl_txn_request_lines mol,
14275: mtl_material_transactions_temp mmtt ,
14276: (SELECT wlpn.lpn_id /*5723418*/
14277: FROM wms_license_plate_numbers wlpn
14278: START WITH wlpn.lpn_id = p_lpn_id
14279: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id ) wlpn
14364: SELECT mmtt.inventory_item_id
14365: , mmtt.locator_id
14366: , mmtt.transaction_quantity
14367: , mmtt.transaction_uom
14368: FROM mtl_material_transactions_temp mmtt,
14369: mtl_txn_request_lines mtrl ,
14370: (SELECT lpn_id /*5723418*/
14371: FROM wms_license_plate_numbers
14372: START WITH lpn_id = p_lpn_id
14770: mmtt.primary_quantity,
14771: mmtt.inventory_item_id,
14772: mol.crossdock_type,
14773: mol.backorder_delivery_detail_id
14774: FROM mtl_material_transactions_temp mmtt,
14775: mtl_txn_request_lines mol
14776: WHERE mmtt.move_order_line_id(+) = mol.line_id
14777: AND mmtt.wms_task_type=2
14778: AND mol.organization_id = mmtt.organization_id(+)