VIEW: APPS.OKL_AM_FIXED_ASSET_LOCATION_UV

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)