APPS.OKL_QUOTE_TOP_LINE_UV
[Home] [Help]
| Product: | OKL - Lease and Finance Management |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.OKL_QUOTE_TOP_LINE_UV
|
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(+)