eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKL_CS_ALC_SUMMARY_UV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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