How To Join DOS_SUPPLY_LINES And INV_TRANSFER_ORDER_LINES For SUPPLY_OPERATION = 'UPDATE'
(Doc ID 2417185.1)
Last updated on JUNE 29, 2018
Applies to:Oracle Fusion Order Management Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.
How to join DOS_SUPPLY_LINES and INV_TRANSFER_ORDER_LINES for SUPPLY_OPERATION = 'UPDATE'
i.e in the table DOS_SUPPLY_LINES where SUPPLY_OPERATION = 'UPDATE' and status_code = 'CLOSED' and supply_type = 'TRANSFER', we need to identify the transfer order header and line details.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!