VIEW: APPS.OKX_AST_DST_HST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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