Internal Sales order(ISO) complete table links

select *
from oe_order_headers_all  --10264383
where order_number = '50745969'

select * from oe_order_headers_all
where header_id  = 20917397

select line_id,header_id,shipped_quantity,shipping_quantity,actual_shipment_date
from oe_order_lines_all
where header_id in  (44114275)

select *
from oe_order_lines_all
where line_id = 44114276

select a.OE_INTERFACED_FLAG,a.released_status,a.*
from wsh_delivery_details a
where source_header_id = 44114275
and source_line_id = 60448452

select * from WSH_DELIVERY_ASSIGNMENTS
where DELIVERY_DETAIL_ID = 59190224

select * from wsh_new_deliveries
where delivery_id = 944758069

select * from MTL_RESERVATIONS
where demand_source_line_id = 60448452  --SO line_id

select * from MTL_DEMAND
where DEMAND_SOURCE_LINE = 60448452


select *
from mtl_reservations a,
        mtl_txn_source_types b
where a.demand_source_type_id   = b.transaction_source_type_id
and a.reservation_id = 118436547


MTL_TXN_REQUEST_HEADERS

select * from MTL_TXN_REQUEST_LINES
where TXN_SOURCE_LINE_ID = 60448452

select TRX_SOURCE_LINE_ID,a.*
from MTL_MATERIAL_TRANSACTIONS_TEMP a
where organization_id in (48,49) 
--TRX_SOURCE_LINE_ID = 13417364


select * from MTL_MATERIAL_TRANSACTIONS
where TRX_SOURCE_LINE_ID = 60435549


select * from MTL_ONHAND_TOTAL_MWB_V
where organization_id in (92,93)
AND inventory_item_id = 2912403
and SUBINVENTORY_CODE = 'STG'


select * from RA_INTERFACE_LINES_ALL
where INTERFACE_LINE_ATTRIBUTE6  = '60435547'


select * from fnd_concurrent_requests where REQUEST_ID = 184354237

select * from org_organization_definitions
where operating_unit = 44


select * from MTL_TRANSACTIONS_INTERFACE
where SOURCE_LINE_ID = 60448453