View: FA_DISTRIBUTION_INQUIRY_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_DISTRIBUTION_INQUIRY_V

View Text

SELECT DH_OUT.ROWID ROW_ID
, DH_OUT.DISTRIBUTION_ID ID
, DH_OUT.TRANSACTION_UNITS TRANS_UNITS
, DH_OUT.UNITS_ASSIGNED UNITS
, TH_OUT.TRANSACTION_TYPE_CODE TRANSTYPE
, DH_OUT.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID
, DH_OUT.LOCATION_ID
, DH_OUT.ASSIGNED_TO
, DH_OUT.CODE_COMBINATION_ID
, A.ASSET_NUMBER
, A.ASSET_ID
, DH_OUT.BOOK_TYPE_CODE
, DH_OUT.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_KEY
, DH_OUT.LAST_UPDATE_DATE
, DH_OUT.LAST_UPDATED_BY
, DH_OUT.LAST_UPDATE_LOGIN
FROM FA_DISTRIBUTION_HISTORY DH_OUT
, FA_TRANSACTION_HEADERS TH_OUT
, FA_ADDITIONS_B A
WHERE A.ASSET_ID = DH_OUT.ASSET_ID
AND DH_OUT.TRANSACTION_HEADER_ID_IN = TH_OUT.TRANSACTION_HEADER_ID
AND DH_OUT.BOOK_TYPE_CODE = TH_OUT.BOOK_TYPE_CODE
AND DH_OUT.ASSET_ID = TH_OUT.ASSET_ID UNION SELECT DH.ROWID ROW_ID
, DH.DISTRIBUTION_ID
, DH.UNITS_ASSIGNED
, DH.UNITS_ASSIGNED
, TH_IN.TRANSACTION_TYPE_CODE
, TH_IN.TRANSACTION_HEADER_ID
, DH.LOCATION_ID
, DH.ASSIGNED_TO
, DH.CODE_COMBINATION_ID
, A.ASSET_NUMBER
, A.ASSET_ID
, DH.BOOK_TYPE_CODE
, DH.TRANSACTION_HEADER_ID_IN
, DH.LAST_UPDATE_DATE
, DH.LAST_UPDATED_BY
, DH.LAST_UPDATE_LOGIN
FROM FA_DISTRIBUTION_HISTORY DH
, FA_TRANSACTION_HEADERS TH_IN
, FA_ADDITIONS_B A
WHERE A.ASSET_ID = DH.ASSET_ID
AND DH.TRANSACTION_HEADER_ID_IN = TH_IN.TRANSACTION_HEADER_ID
AND TH_IN.ASSET_ID = A.ASSET_ID
AND TH_IN.BOOK_TYPE_CODE = DH.BOOK_TYPE_CODE
AND (DH.CODE_COMBINATION_ID
, DH.LOCATION_ID
, NVL(DH.ASSIGNED_TO
, -99)) NOT IN (SELECT DHX.CODE_COMBINATION_ID
, DHX.LOCATION_ID
, NVL(DHX.ASSIGNED_TO
, -99)
FROM FA_DISTRIBUTION_HISTORY DHX
WHERE DHX.TRANSACTION_HEADER_ID_OUT = DH.TRANSACTION_HEADER_ID_IN)

Columns