VIEW: APPS.OKL_LA_ASSET_IB_UV

Source

View Text - Preformatted

SELECT clt.id top_line, cle_ib.id ib_id, cle.dnz_chr_id dnz_chr_id, clt.name asset_number, clt.item_description description, cim.object1_id1 inventory_item_id, cim.object1_id2 inventory_org_id, cim.number_of_items units, iti.object_id1_new object_id1_new, iti.object_id2_new object_id2_new, substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null, null,null,null,null,null,null,'n','n',80,1,1),1,80) address_description FROM HZ_LOCATIONS HL,HZ_PARTY_SITES HPS,HZ_PARTY_SITE_USES HPSU,OKL_TXL_ITM_INSTS ITI,OKC_LINE_STYLES_B LSE_IB,OKC_K_LINES_B CLE_IB,OKC_LINE_STYLES_B LSE_INST,OKC_K_LINES_B CLE_INST,OKC_LINE_STYLES_B LSE_ML,OKC_K_ITEMS CIM,OKC_K_LINES_B CLE_ML,OKC_LINE_STYLES_B LSE,OKC_K_LINES_TL CLT,OKC_K_LINES_B CLE WHERE cle.cle_id is null and cle.chr_id = cle.dnz_chr_id and clt.id = cle.id and clt.language = USERENV('LANG') and lse.id = cle.lse_id and lse.lty_code = 'FREE_FORM1' and cle_ml.cle_id = cle.id and cle_ml.dnz_chr_id = cle.dnz_chr_id and cim.cle_id = cle_ml.id and cim.dnz_chr_id = cle_ml.dnz_chr_id and lse_ml.id = cle_ml.lse_id and lse_ml.lty_code = 'ITEM' and cle_inst.cle_id = cle.id and cle_inst.dnz_chr_id = cle.dnz_chr_id and cle_inst.lse_id = lse_inst.id and lse_inst.lty_code = 'FREE_FORM2' and cle_ib.cle_id = cle_inst.id and cle_ib.dnz_chr_id = cle.dnz_chr_id and cle_ib.lse_id = lse_ib.id and lse_ib.lty_code = 'INST_ITEM' and iti.kle_id = cle_ib.id and iti.object_id1_new = hpsu.party_site_use_id and iti.object_id2_new = '#' and hpsu.party_site_id = hps.party_site_id and hps.location_id = hl.location_id

View Text - HTML Formatted

SELECT CLT.ID TOP_LINE
, CLE_IB.ID IB_ID
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, CLT.NAME ASSET_NUMBER
, CLT.ITEM_DESCRIPTION DESCRIPTION
, CIM.OBJECT1_ID1 INVENTORY_ITEM_ID
, CIM.OBJECT1_ID2 INVENTORY_ORG_ID
, CIM.NUMBER_OF_ITEMS UNITS
, ITI.OBJECT_ID1_NEW OBJECT_ID1_NEW
, ITI.OBJECT_ID2_NEW OBJECT_ID2_NEW
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, HL.ADDRESS1
, HL.ADDRESS2
, HL.ADDRESS3
, HL.ADDRESS4
, HL.CITY
, HL.COUNTY
, HL.STATE
, HL.PROVINCE
, HL.POSTAL_CODE
, NULL
, HL.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) ADDRESS_DESCRIPTION
FROM HZ_LOCATIONS HL
, HZ_PARTY_SITES HPS
, HZ_PARTY_SITE_USES HPSU
, OKL_TXL_ITM_INSTS ITI
, OKC_LINE_STYLES_B LSE_IB
, OKC_K_LINES_B CLE_IB
, OKC_LINE_STYLES_B LSE_INST
, OKC_K_LINES_B CLE_INST
, OKC_LINE_STYLES_B LSE_ML
, OKC_K_ITEMS CIM
, OKC_K_LINES_B CLE_ML
, OKC_LINE_STYLES_B LSE
, OKC_K_LINES_TL CLT
, OKC_K_LINES_B CLE
WHERE CLE.CLE_ID IS NULL
AND CLE.CHR_ID = CLE.DNZ_CHR_ID
AND CLT.ID = CLE.ID
AND CLT.LANGUAGE = USERENV('LANG')
AND LSE.ID = CLE.LSE_ID
AND LSE.LTY_CODE = 'FREE_FORM1'
AND CLE_ML.CLE_ID = CLE.ID
AND CLE_ML.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CIM.CLE_ID = CLE_ML.ID
AND CIM.DNZ_CHR_ID = CLE_ML.DNZ_CHR_ID
AND LSE_ML.ID = CLE_ML.LSE_ID
AND LSE_ML.LTY_CODE = 'ITEM'
AND CLE_INST.CLE_ID = CLE.ID
AND CLE_INST.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CLE_INST.LSE_ID = LSE_INST.ID
AND LSE_INST.LTY_CODE = 'FREE_FORM2'
AND CLE_IB.CLE_ID = CLE_INST.ID
AND CLE_IB.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CLE_IB.LSE_ID = LSE_IB.ID
AND LSE_IB.LTY_CODE = 'INST_ITEM'
AND ITI.KLE_ID = CLE_IB.ID
AND ITI.OBJECT_ID1_NEW = HPSU.PARTY_SITE_USE_ID
AND ITI.OBJECT_ID2_NEW = '#'
AND HPSU.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID