How To Join DOS_SUPPLY_LINES And INV_TRANSFER_ORDER_LINES For SUPPLY_OPERATION = 'UPDATE'
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms