VIEW: APPS.OKL_QUOTE_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 , sle_cle.id sub_line_id, sle_cle.cle_id sub_line_cle_id, sle_cle.sts_code sub_line_sts_code, sle_cle.currency_code sub_line_currency_code, sle_cle.line_number sub_line_line_number, sle_cle.display_sequence sub_line_display_sequence, sle_cle.lse_id sub_line_lse_id, sle_cle.start_date sub_line_start_date, sle_cle.end_date sub_line_end_date, sle_kle.capital_amount sub_line_capital_amount, sle_cle.dnz_chr_id sub_line_dnz_chr_id, sle_cle.chr_id sub_line_chr_id, link_ast.id link_ast_id, link_ast.cle_id link_ast_cle_id, link_ast.OBJECT1_ID1 link_ast_object1_id1, link_ast.OBJECT1_ID2 link_ast_object1_id2, link_ast.JTOT_OBJECT1_CODE link_ast_jtot_object1_code, link_ast.chr_id link_ast_chr_id, link_ast.dnz_chr_id link_ast_dnz_chr_id, link_ast.uom_code link_ast_uom_code, link_ast.exception_yn link_ast_exception_yn, link_ast.number_of_items link_ast_number_of_items, sle_lse.lty_code sub_line_lty_code 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,OKC_K_LINES_B SLE_CLE,OKL_K_LINES SLE_KLE,OKC_K_ITEMS LINK_AST,OKC_LINE_STYLES_B SLE_LSE WHERE lse.id = cle.lse_id AND kle.id = cle.id AND item.cle_id = cle.id AND party.cle_id(+) = cle.id AND item.dnz_chr_id = cle.dnz_chr_id AND sle_cle.cle_id(+) = cle.id AND sle_cle.id = sle_kle.id (+) AND link_ast.cle_id(+) = sle_cle.id AND sle_cle.lse_id = sle_lse.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
, SLE_CLE.ID SUB_LINE_ID
, SLE_CLE.CLE_ID SUB_LINE_CLE_ID
, SLE_CLE.STS_CODE SUB_LINE_STS_CODE
, SLE_CLE.CURRENCY_CODE SUB_LINE_CURRENCY_CODE
, SLE_CLE.LINE_NUMBER SUB_LINE_LINE_NUMBER
, SLE_CLE.DISPLAY_SEQUENCE SUB_LINE_DISPLAY_SEQUENCE
, SLE_CLE.LSE_ID SUB_LINE_LSE_ID
, SLE_CLE.START_DATE SUB_LINE_START_DATE
, SLE_CLE.END_DATE SUB_LINE_END_DATE
, SLE_KLE.CAPITAL_AMOUNT SUB_LINE_CAPITAL_AMOUNT
, SLE_CLE.DNZ_CHR_ID SUB_LINE_DNZ_CHR_ID
, SLE_CLE.CHR_ID SUB_LINE_CHR_ID
, LINK_AST.ID LINK_AST_ID
, LINK_AST.CLE_ID LINK_AST_CLE_ID
, LINK_AST.OBJECT1_ID1 LINK_AST_OBJECT1_ID1
, LINK_AST.OBJECT1_ID2 LINK_AST_OBJECT1_ID2
, LINK_AST.JTOT_OBJECT1_CODE LINK_AST_JTOT_OBJECT1_CODE
, LINK_AST.CHR_ID LINK_AST_CHR_ID
, LINK_AST.DNZ_CHR_ID LINK_AST_DNZ_CHR_ID
, LINK_AST.UOM_CODE LINK_AST_UOM_CODE
, LINK_AST.EXCEPTION_YN LINK_AST_EXCEPTION_YN
, LINK_AST.NUMBER_OF_ITEMS LINK_AST_NUMBER_OF_ITEMS
, SLE_LSE.LTY_CODE SUB_LINE_LTY_CODE
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
, OKC_K_LINES_B SLE_CLE
, OKL_K_LINES SLE_KLE
, OKC_K_ITEMS LINK_AST
, OKC_LINE_STYLES_B SLE_LSE
WHERE LSE.ID = CLE.LSE_ID
AND KLE.ID = CLE.ID
AND ITEM.CLE_ID = CLE.ID
AND PARTY.CLE_ID(+) = CLE.ID
AND ITEM.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND SLE_CLE.CLE_ID(+) = CLE.ID
AND SLE_CLE.ID = SLE_KLE.ID (+)
AND LINK_AST.CLE_ID(+) = SLE_CLE.ID
AND SLE_CLE.LSE_ID = SLE_LSE.ID(+)