Sometime , We need to know specific relationship between some important tables .
Lets come to know one such important SQL Query to know the relationship between Transfer Order, Pick Slip Number, and Supply Orchestration
SQL Query can be used to show the link between a Transfer Order, Pick Slip Number, and Supply Orchestration
Belo is the screenshot for instance
The Required output We need from the report is below
The Query used for above requirement is below
SELECT
a.pick_slip_number ,
b.source_header_number transfer_order_number,
c.supply_order_number ,
c.supply_order_reference_number
FROM
INV_PICK_SLIP_NUMBERS a ,
WSH_DELIVERY_DETAILS b ,
DOS_SUPPLY_HEADERS c ,
INV_TRANSFER_ORDER_HEADERS d,
INV_TRANSFER_ORDER_LINES e
WHERE 1 =1
AND a.PICK_SLIP_NUMBER = 11022
AND a.pick_slip_batch_id = b.batch_id
AND b.source_header_number = d.header_number
AND d.header_id = e.header_id
AND e.source_header_id = c.header_id
Thank you , Please do comment and share here .
Happy Leaning !!!
Comments
Post a Comment