VIEW: APPS.OKL_LA_SERIAL_NUMBER_UV

Source

View Text - Preformatted

SELECT null id, cle_ib.id kle_id, cle_fin.id dnz_cle_id, cle_fin.dnz_chr_id dnz_chr_id, csi.serial_number serial_number, csi.instance_number instance_number_ib, csi.inventory_item_id inventory_item_id, csi.inv_organization_id inventory_org_id, csi.inv_master_organization_id inv_master_org_id, hpsu.party_site_use_id object_id1_new, '#' object_id2_new FROM HZ_LOCATIONS HL,HZ_PARTY_SITES HPS,HZ_PARTY_SITE_USES HPSU,CSI_ITEM_INSTANCES CSI,OKC_K_ITEMS CIM_IB,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_FIN,OKC_K_LINES_B CLE_FIN WHERE cle_fin.cle_id is null and cle_fin.chr_id = cle_fin.dnz_chr_id and lse_fin.id = cle_fin.lse_id and lse_fin.lty_code = 'FREE_FORM1' and cle_inst.cle_id = cle_fin.id and cle_inst.dnz_chr_id = cle_fin.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_fin.dnz_chr_id and cle_ib.lse_id = lse_ib.id and lse_ib.lty_code = 'INST_ITEM' and cim_ib.cle_id = cle_ib.id and cim_ib.dnz_chr_id = cle_ib.dnz_chr_id and cim_ib.object1_id1 = csi.instance_id and cim_ib.object1_id2 = '#' and cim_ib.jtot_object1_code = 'OKX_IB_ITEM' and csi.install_location_id = hpsu.party_site_id and hpsu.site_use_type = 'INSTALL_AT' and hpsu.party_site_id = hps.party_site_id and hps.location_id = hl.location_id

View Text - HTML Formatted

SELECT NULL ID
, CLE_IB.ID KLE_ID
, CLE_FIN.ID DNZ_CLE_ID
, CLE_FIN.DNZ_CHR_ID DNZ_CHR_ID
, CSI.SERIAL_NUMBER SERIAL_NUMBER
, CSI.INSTANCE_NUMBER INSTANCE_NUMBER_IB
, CSI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CSI.INV_ORGANIZATION_ID INVENTORY_ORG_ID
, CSI.INV_MASTER_ORGANIZATION_ID INV_MASTER_ORG_ID
, HPSU.PARTY_SITE_USE_ID OBJECT_ID1_NEW
, '#' OBJECT_ID2_NEW
FROM HZ_LOCATIONS HL
, HZ_PARTY_SITES HPS
, HZ_PARTY_SITE_USES HPSU
, CSI_ITEM_INSTANCES CSI
, OKC_K_ITEMS CIM_IB
, 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_FIN
, OKC_K_LINES_B CLE_FIN
WHERE CLE_FIN.CLE_ID IS NULL
AND CLE_FIN.CHR_ID = CLE_FIN.DNZ_CHR_ID
AND LSE_FIN.ID = CLE_FIN.LSE_ID
AND LSE_FIN.LTY_CODE = 'FREE_FORM1'
AND CLE_INST.CLE_ID = CLE_FIN.ID
AND CLE_INST.DNZ_CHR_ID = CLE_FIN.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_FIN.DNZ_CHR_ID
AND CLE_IB.LSE_ID = LSE_IB.ID
AND LSE_IB.LTY_CODE = 'INST_ITEM'
AND CIM_IB.CLE_ID = CLE_IB.ID
AND CIM_IB.DNZ_CHR_ID = CLE_IB.DNZ_CHR_ID
AND CIM_IB.OBJECT1_ID1 = CSI.INSTANCE_ID
AND CIM_IB.OBJECT1_ID2 = '#'
AND CIM_IB.JTOT_OBJECT1_CODE = 'OKX_IB_ITEM'
AND CSI.INSTALL_LOCATION_ID = HPSU.PARTY_SITE_ID
AND HPSU.SITE_USE_TYPE = 'INSTALL_AT'
AND HPSU.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID