SO到订单行Closed
[sql] www.2cto.com
--entered
SELECT * FROM inv.mtl_sales_orders WHERE segment1 = 1054627; --sales_order_id:935491
SELECT h.flow_status_code, h.* --header_id:6577988 --flow_status_code:entered
FROM ont.oe_order_headers_all h
WHERE order_number = 1054627;
SELECT l.flow_status_code, l * --flow_status_code:entered
FROM ont.oe_order_lines_all l
WHERE header_id = 6577988
AND line_id = 15514837;
/*select *
from inv.mtl_onhand_quantities_detail
where inventory_item_id = 13139193
and organization_id = 87;
select *
from inv.mtl_system_items_b
where segment1 = 'TCS_707534'
and organization_id = 87;*/
--------------------------------------
--booked Book之后产生发运明细记录，对应Shipping Transaction Form
SELECT h.flow_status_code, h.* --header_id:6577988 --flow_status_code:booked
FROM ont.oe_order_headers_all h
WHERE order_number = 1054627;
SELECT l.flow_status_code, l.* --flow_status_code:AWAITING_SHIPPING
FROM ont.oe_order_lines_all l
WHERE header_id = 6577988
AND line_id = 15514837;
SELECT * --delivery_detail_id:7661571 released_status:R (Ready to release) Shipping Transaction Form
FROM wsh.wsh_delivery_details
WHERE source_header_id = 6577988
AND source_line_id = 15514837;
SELECT *
FROM wsh.wsh_delivery_assignments
WHERE delivery_detail_id = 7661571;
---------------------------------------
--Released Release之后产生Move Order和Pendding Transaction记录
SELECT h.flow_status_code, h.* --header_id:6577988 --flow_status_code:booked
FROM ont.oe_order_headers_all h
WHERE order_number = 1054627;
SELECT l.flow_status_code, l.* --flow_status_code:AWAITING_SHIPPING
FROM ont.oe_order_lines_all l
WHERE header_id = 6577988
AND line_id = 15514837;
SELECT d.released_status, d.* --delivery_detail_id:7661571 released_status:S (Released to Warehouse) Shipping Transaction Form
FROM wsh.wsh_delivery_details d
WHERE source_header_id = 6577988
AND source_line_id = 15514837;
SELECT *
FROM wsh.wsh_delivery_assignments
WHERE delivery_detail_id = 7661571;
SELECT * --line_status:7
FROM inv.mtl_txn_request_lines
WHERE txn_source_id = 935491
AND txn_source_line_id = 15514837;
SELECT * FROM inv.mtl_txn_request_headers WHERE header_id = 7098004; --request_number:7097984 header_status:7
SELECT * FROM wsh.wsh_picking_batches WHERE order_header_id = 6577988;
SELECT * --transaction_temp_id:119820378 will be the key of MMT, move_order_line_id:126685846 move_order_header_id:7098004
FROM mtl_material_transactions_temp
WHERE transaction_source_id = 935491
AND trx_source_line_id = 15514837;
------------------------------------------
--picked Pick之后，Move Order和Pendding Transaction结束
SELECT h.flow_status_code, h.* --header_id:6577988 --flow_status_code:booked
FROM ont.oe_order_headers_all h
WHERE order_number = 1054627;
SELECT l.flow_status_code, l.* --flow_status_code:AWAITING_SHIPPING
FROM ont.oe_order_lines_all l