VIEW: APPS.OKL_K_TOP_LINE_UV

Source

View Text - Preformatted

SELECT cle.id line_id, cle.cle_id line_cle_id, cle.sts_code line_sts_code, cle.currency_code line_currency_code, cle.line_number line_line_number, cle.display_sequence line_display_sequence, cle.lse_id line_lse_id, cle.start_date line_start_date, cle.end_date line_end_date, kle.amount line_amount, kle.capital_amount line_capital_amount, cle.dnz_chr_id line_dnz_chr_id, cle.chr_id line_chr_id, item.id item_id, item.cle_id item_cle_id, item.OBJECT1_ID1 item_object1_id1, item.OBJECT1_ID2 item_object1_id2, item.JTOT_OBJECT1_CODE item_jtot_object1_code, item.chr_id item_chr_id, item.dnz_chr_id item_dnz_chr_id, item.uom_code item_uom_code, item.exception_yn item_exception_yn, item.number_of_items item_number_of_items, lse.lty_code ls_lty_code, lse.id ls_id, party.id party_id, party.rle_code party_rle_code, party.cle_id party_cle_id, party.object1_id1 party_object1_id1, party.object1_id2 party_object1_id2, party.jtot_object1_code party_jtot_object1_code, party.dnz_chr_id party_dnz_chr_id, KLE.attribute_category attribute_category, KLE.attribute1 attribute1, KLE.attribute2 attribute2, KLE.attribute3 attribute3, KLE.attribute4 attribute4, KLE.attribute5 attribute5, KLE.attribute6 attribute6, KLE.attribute7 attribute7, KLE.attribute8 attribute8, KLE.attribute9 attribute9, KLE.attribute10 attribute10, KLE.attribute11 attribute11, KLE.attribute12 attribute12, KLE.attribute13 attribute13, KLE.attribute14 attribute14, KLE.attribute15 attribute15 FROM OKC_K_LINES_B CLE,OKL_K_LINES KLE,OKC_LINE_STYLES_B LSE,OKC_K_ITEMS ITEM,OKC_K_PARTY_ROLES_B PARTY WHERE lse.id = cle.lse_id and kle.id = cle.id and item.cle_id = cle.id and party.cle_id(+) = cle.id and party.dnz_chr_id(+) = cle.dnz_chr_id and item.dnz_chr_id = cle.dnz_chr_id

View Text - HTML Formatted

SELECT CLE.ID LINE_ID
, CLE.CLE_ID LINE_CLE_ID
, CLE.STS_CODE LINE_STS_CODE
, CLE.CURRENCY_CODE LINE_CURRENCY_CODE
, CLE.LINE_NUMBER LINE_LINE_NUMBER
, CLE.DISPLAY_SEQUENCE LINE_DISPLAY_SEQUENCE
, CLE.LSE_ID LINE_LSE_ID
, CLE.START_DATE LINE_START_DATE
, CLE.END_DATE LINE_END_DATE
, KLE.AMOUNT LINE_AMOUNT
, KLE.CAPITAL_AMOUNT LINE_CAPITAL_AMOUNT
, CLE.DNZ_CHR_ID LINE_DNZ_CHR_ID
, CLE.CHR_ID LINE_CHR_ID
, ITEM.ID ITEM_ID
, ITEM.CLE_ID ITEM_CLE_ID
, ITEM.OBJECT1_ID1 ITEM_OBJECT1_ID1
, ITEM.OBJECT1_ID2 ITEM_OBJECT1_ID2
, ITEM.JTOT_OBJECT1_CODE ITEM_JTOT_OBJECT1_CODE
, ITEM.CHR_ID ITEM_CHR_ID
, ITEM.DNZ_CHR_ID ITEM_DNZ_CHR_ID
, ITEM.UOM_CODE ITEM_UOM_CODE
, ITEM.EXCEPTION_YN ITEM_EXCEPTION_YN
, ITEM.NUMBER_OF_ITEMS ITEM_NUMBER_OF_ITEMS
, LSE.LTY_CODE LS_LTY_CODE
, LSE.ID LS_ID
, PARTY.ID PARTY_ID
, PARTY.RLE_CODE PARTY_RLE_CODE
, PARTY.CLE_ID PARTY_CLE_ID
, PARTY.OBJECT1_ID1 PARTY_OBJECT1_ID1
, PARTY.OBJECT1_ID2 PARTY_OBJECT1_ID2
, PARTY.JTOT_OBJECT1_CODE PARTY_JTOT_OBJECT1_CODE
, PARTY.DNZ_CHR_ID PARTY_DNZ_CHR_ID
, KLE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KLE.ATTRIBUTE1 ATTRIBUTE1
, KLE.ATTRIBUTE2 ATTRIBUTE2
, KLE.ATTRIBUTE3 ATTRIBUTE3
, KLE.ATTRIBUTE4 ATTRIBUTE4
, KLE.ATTRIBUTE5 ATTRIBUTE5
, KLE.ATTRIBUTE6 ATTRIBUTE6
, KLE.ATTRIBUTE7 ATTRIBUTE7
, KLE.ATTRIBUTE8 ATTRIBUTE8
, KLE.ATTRIBUTE9 ATTRIBUTE9
, KLE.ATTRIBUTE10 ATTRIBUTE10
, KLE.ATTRIBUTE11 ATTRIBUTE11
, KLE.ATTRIBUTE12 ATTRIBUTE12
, KLE.ATTRIBUTE13 ATTRIBUTE13
, KLE.ATTRIBUTE14 ATTRIBUTE14
, KLE.ATTRIBUTE15 ATTRIBUTE15
FROM OKC_K_LINES_B CLE
, OKL_K_LINES KLE
, OKC_LINE_STYLES_B LSE
, OKC_K_ITEMS ITEM
, OKC_K_PARTY_ROLES_B PARTY
WHERE LSE.ID = CLE.LSE_ID
AND KLE.ID = CLE.ID
AND ITEM.CLE_ID = CLE.ID
AND PARTY.CLE_ID(+) = CLE.ID
AND PARTY.DNZ_CHR_ID(+) = CLE.DNZ_CHR_ID
AND ITEM.DNZ_CHR_ID = CLE.DNZ_CHR_ID