Product: | OKX - Contracts Integration |
---|---|
Description: | Information regarding employee, location, expense account flexfield assigned to an asset. |
Implementation/DBA Data: | APPS.OKX_AST_DST_HST_V |
SELECT FDH.DISTRIBUTION_ID ID1
, '#' ID2
, FA.ASSET_NUMBER NAME
, FDH.BOOK_TYPE_CODE DESCRIPTION
, FDH.ASSET_ID ASSET_ID
, FDH.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FDH.DISTRIBUTION_ID DISTRIBUTION_ID
, FDH.UNITS_ASSIGNED UNITS_ASSIGNED
, FDH.CODE_COMBINATION_ID CODE_COMBINATION_ID
, FDH.LOCATION_ID LOCATION_ID
, FDH.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, FDH.DATE_EFFECTIVE START_DATE_ACTIVE
, FDH.DATE_INEFFECTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(FDH.DATE_EFFECTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(FDH.DATE_INEFFECTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
, FDH.ASSIGNED_TO ASSIGNED_TO
, FDH.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, FDH.TRANSACTION_UNITS TRANSACTION_UNITS
, FDH.RETIREMENT_ID RETIREMENT_ID
FROM FA_DISTRIBUTION_HISTORY FDH
, FA_ADDITIONS_B FA
WHERE FDH.ASSET_ID = FA.ASSET_ID