Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_FIXED_ASSET_LOCATION_UV |
SELECT CLEV.ID ID
, CLEV.NAME NAME
, CLEV.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLEV.CHR_ID CHR_ID
, OKHV.CONTRACT_NUMBER CONTRACT_NUMBER
, OKHV.STS_CODE CONTRACT_STATUS
, CLEV.START_DATE START_DATE
, CLEV.END_DATE END_DATE
, CLEV.STS_CODE LINE_STATUS
, CLEV.OEC OEC
, OALV.ASSET_TYPE ASSET_TYPE
, OALV.CORPORATE_BOOK CORPORATE_BOOK
, OALV.ASSET_ID FA_ASSET_ID
, OALV.ASSET_NUMBER FA_ASSET_NUMBER
, FDH.DISTRIBUTION_ID DISTRIBUTION_ID
, FDH.UNITS_ASSIGNED UNITS_ASSIGNED
, FDH.TRANSACTION_UNITS TRANSACTION_UNITS
, OALV.CURRENT_UNITS CURRENT_UNITS
, FDH.ASSIGNED_TO ASSIGNED_TO
, FDH.CODE_COMBINATION_ID CODE_COMBINATION_ID
, FDH.LOCATION_ID LOCATION_ID
, OAL.NAME LOCATION_NAME
, TO_CHAR(NULL) NEW_LOCATION_NAME
, TO_NUMBER(NULL) NEW_LOCATION_ID
FROM OKL_K_LINES_FULL_V CLEV
, OKX_ASSET_LINES_V OALV
, OKC_K_HEADERS_B OKHV
, OKC_LINE_STYLES_V LSEV
, OKX_AST_DST_HST_V FDH
, OKX_AST_LOCS_V OAL
WHERE CLEV.ID = OALV.PARENT_LINE_ID (+)
AND CLEV.CHR_ID = OKHV.ID
AND CLEV.LSE_ID = LSEV.ID
AND LSEV.LTY_CODE = 'FREE_FORM1'
AND OALV.ASSET_ID = FDH.ASSET_ID (+)
AND OALV.CORPORATE_BOOK = FDH.BOOK_TYPE_CODE (+)
AND FDH.TRANSACTION_HEADER_ID_OUT IS NULL
AND FDH.LOCATION_ID = OAL.LOCATION_ID (+)