h.wsh_new_deliveries wnd
WHERE source_header_id = 6577988;
SELECT *
FROM wsh.wsh_delivery_assignments
WHERE delivery_detail_id = 7661571
AND delivery_id = 9731514;
SELECT * --transaction_type_id:52 52 33
FROM inv.mtl_material_transactions
WHERE transaction_source_id = 935491 --sales_order_id
AND trx_source_line_id = 15514837; --line_id
SELECT * --Sales Order Pick,Sales Order Pick,Sales order issue
FROM inv.mtl_transaction_types
WHERE transaction_type_id IN (52, 33);
SELECT *
FROM inv.mtl_onhand_quantities_detail
WHERE inventory_item_id = 13139193
AND organization_id = 87;
---------------------------------------------
--System Administrator/Requests/Workflow Background Process
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:CLOSED
FROM ont.oe_order_lines_all l
WHERE header_id = 6577988
AND line_id = 15514837;
--------------------------------------------
--AR/Requests/Run/Autoinvoice Import Program
SELECT *
FROM ra_interface_lines_all
WHERE trunc(SYSDATE) = trunc(creation_date);
[sql] www.2cto.com
ont.oe_order_headers_all
ont.oe_order_lines_all
wsh.wsh_delivery_details
wsh.wsh_delivery_assignments
inv.mtl_txn_request_headers
inv.mtl_txn_request_lines
mtl_material_transactions_temp
inv.mtl_material_transactions
wsh.wsh_new_deliveries
inv.mtl_transaction_types
inv.mtl_onhand_quantities_detail
inv.mtl_system_items_b