[Home] [Help]
2513: print_debug('In Create Move Order', l_debug);
2514: SAVEPOINT create_move_order;
2515: --x_return_status := fnd_api.g_ret_sts_success;
2516:
2517: SELECT MTL_TXN_REQUEST_HEADERS_S.NEXTVAL
2518: into l_request_number
2519: FROM SYS.DUAL;
2520:
2521: l_mo_header_id := INV_TRANSFER_ORDER_PVT.get_next_header_id;
2519: FROM SYS.DUAL;
2520:
2521: l_mo_header_id := INV_TRANSFER_ORDER_PVT.get_next_header_id;
2522:
2523: INSERT INTO mtl_txn_request_headers
2524: (HEADER_ID,
2525: REQUEST_NUMBER,
2526: TRANSACTION_TYPE_ID,
2527: MOVE_ORDER_TYPE,
4897: DELETE FROM mtl_txn_request_Lines WHERE header_id=p_mo_header_id;
4898:
4899: print_debug(SQL%ROWCOUNT || ' Rows deleted from MTRL ', l_debug);
4900:
4901: DELETE FROM mtl_txn_request_headers WHERE header_id=p_mo_header_id;
4902:
4903: print_debug(SQL%ROWCOUNT || ' Rows deleted from MTRH ', l_debug);
4904:
4905: process_reservations(p_wave_id => p_wave_id
17625: l_sec_qty,
17626: l_org_id,
17627: l_mo_type
17628: FROM mtl_material_transactions_temp mtrl,
17629: mtl_txn_request_headers mtrh
17630: WHERE mtrl.transaction_temp_id = l_txn_temp_id
17631: AND mtrh.header_id = mtrl.move_order_header_id;
17632:
17633: -- move order type : 2:Replenishment 3:Pick Wave 6:Crossdocking
18667: WMS_WP_WAVE_LINES WWL,
18668: wms_dispatched_tasks wdt,
18669: bom_standard_operations bso,
18670: bom_resources br1,
18671: mtl_txn_request_headers mtrh,
18672: mtl_txn_request_lines mtrl,
18673: wms_replenishment_Details wrd
18674: where mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
18675: and mtrl.header_id = mtrh.header_id
19165: wms_dispatched_tasks_history wdth,
19166: bom_standard_operations bso,
19167: bom_resources br1,
19168: mtl_txn_request_lines mtrl,
19169: mtl_txn_request_headers mtrh
19170: where 1=1
19171: AND wdth.person_id = pap.person_id(+)
19172: AND wdth.effective_start_date >= pap.effective_start_date(+)
19173: AND wdth.effective_end_date <= pap.effective_end_date(+)