View: OKL_CS_ALC_SUMMARY_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_ALC_SUMMARY_UV

View Text

SELECT OKL_LLA_UTIL_PVT.GET_BOOKED_ASSET_NUMBER(TXL.DNZ_CLE_ID
, CHR.ID)
, TXL.DNZ_CLE_ID
, TXL.OBJECT_ID1_OLD
, TXL.OBJECT_ID2_OLD
, TXL.OBJECT_ID1_NEW
, TXL.OBJECT_ID2_NEW
, TRX.DATE_TRANS_OCCURRED DATE_EFFECTIVE
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, HZO.ADDRESS1
, HZO.ADDRESS2
, HZO.ADDRESS3
, HZO.ADDRESS4
, HZO.CITY
, HZO.COUNTY
, HZO.STATE
, HZO.PROVINCE
, HZO.POSTAL_CODE
, NULL
, HZO.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) OLD_LOCATION
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, HZN.ADDRESS1
, HZN.ADDRESS2
, HZN.ADDRESS3
, HZN.ADDRESS4
, HZN.CITY
, HZN.COUNTY
, HZN.STATE
, HZN.PROVINCE
, HZN.POSTAL_CODE
, NULL
, HZN.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) NEW_LOCATION
, SUM(TXS.TOTAL_TAX) TAX_AMOUNT
, CHR.CURRENCY_CODE
, TRX.TSU_CODE
, FLK.MEANING STATUS
, TRX.REQ_ASSET_ID
, CHR.CONTRACT_NUMBER
, SUM(TXS.LINE_AMT) LINE_AMT
, 'Y' ALC_SERIALIZED_YN
FROM OKL_TRX_ASSETS TRX
, OKL_TXL_ITM_INSTS TXL
, OKL_TRX_TYPES_V TRY
, HZ_PARTY_SITE_USES PSUO
, HZ_PARTY_SITE_USES PSUN
, HZ_PARTY_SITES PSO
, HZ_PARTY_SITES PSN
, HZ_LOCATIONS HZO
, HZ_LOCATIONS HZN
, OKC_K_LINES_B CLE
, OKC_K_HEADERS_ALL_B CHR
, FND_LOOKUPS FLK
, OKL_TAX_SOURCES TXS
WHERE TRX.ID = TXL.TAS_ID
AND TRX.TRY_ID = TRY.ID
AND TRY.NAME = 'ASSET RELOCATION'
AND TXL.OBJECT_ID1_OLD = PSUO.PARTY_SITE_USE_ID
AND TXL.OBJECT_ID1_NEW = PSUN.PARTY_SITE_USE_ID
AND PSUO.PARTY_SITE_ID = PSO.PARTY_SITE_ID
AND PSUN.PARTY_SITE_ID = PSN.PARTY_SITE_ID
AND PSO.LOCATION_ID = HZO.LOCATION_ID
AND PSN.LOCATION_ID = HZN.LOCATION_ID
AND TXL.KLE_ID = CLE.ID
AND CLE.DNZ_CHR_ID = CHR.ID
AND FLK.LOOKUP_CODE = TRX.TSU_CODE
AND FLK.LOOKUP_TYPE = 'OKL_REQUEST_STATUS'
AND TXS.TRX_ID (+) = TRX.ID
AND TXS.TAX_CALL_TYPE_CODE (+) = 'UPFRONT_TAX'
AND TXS.ENTITY_CODE (+) = 'ASSETS'
AND TXS.EVENT_CLASS_CODE (+) = 'ASSET_RELOCATION'
AND TXS.TRX_LEVEL_TYPE (+) = 'LINE'
AND TXS.APPLICATION_ID (+) = 540 GROUP BY OKL_LLA_UTIL_PVT.GET_BOOKED_ASSET_NUMBER(TXL.DNZ_CLE_ID
, CHR.ID)
, TXL.DNZ_CLE_ID
, TXL.OBJECT_ID1_OLD
, TXL.OBJECT_ID2_OLD
, TXL.OBJECT_ID1_NEW
, TXL.OBJECT_ID2_NEW
, TRX.DATE_TRANS_OCCURRED
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, HZO.ADDRESS1
, HZO.ADDRESS2
, HZO.ADDRESS3
, HZO.ADDRESS4
, HZO.CITY
, HZO.COUNTY
, HZO.STATE
, HZO.PROVINCE
, HZO.POSTAL_CODE
, NULL
, HZO.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80)
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, HZN.ADDRESS1
, HZN.ADDRESS2
, HZN.ADDRESS3
, HZN.ADDRESS4
, HZN.CITY
, HZN.COUNTY
, HZN.STATE
, HZN.PROVINCE
, HZN.POSTAL_CODE
, NULL
, HZN.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80)
, CHR.CURRENCY_CODE
, TRX.TSU_CODE
, FLK.MEANING
, TRX.REQ_ASSET_ID
, CHR.CONTRACT_NUMBER ORDER BY TRX.DATE_TRANS_OCCURRED DESC

Columns