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.

Goal

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.

 

Solution

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