My Oracle Support Banner

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

To view full 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 a vibrant support community of peers and Oracle experts.