VIEW: APPS.OKI_DBI_CLE_V

Source

View Text - Preformatted

SELECT CHR_ID , CLE_ID , COV_PROD_ID , COV_PROD_SYSTEM_ID , COVERED_ITEM_ID , SERVICE_ITEM_ID , INV_ORGANIZATION_ID , SLE_ID , P_CHR_ID , P_CLE_ID , SCS_CODE , CONTRACT_NUMBER , CONTRACT_NUMBER_MODIFIER , CONTRACT_NUMBER || DECODE( CONTRACT_NUMBER_MODIFIER, NULL, NULL, ' ' || CONTRACT_NUMBER_MODIFIER ) COMPLETE_K_NUMBER , LINE_NUMBER , STS_CODE , TRN_CODE , ORDER_NUMBER , CLE_CREATION_DATE , TRUNC(DATE_CANCELLED) DATE_CANCELLED , TRUNC(DATE_TERMINATED) DATE_TERMINATED , TRUNC(END_DATE - 1) END_DATE , TRUNC(START_DATE) START_DATE , CL_LAST_UPDATE_DATE LAST_UPDATE_DATE , RENEWAL_FLAG , RENEWAL_TYPE RENEWAL_TYPE_CODE , DURATION_QTY , DURATION_UOM , QUANTITY , UOM_CODE , CURR_CODE , CURR_CODE_F , CURR_CODE_G , CURR_CODE_SG , CURR_CODE_A , LIST_PRICE , LIST_PRICE_F , LIST_PRICE_G , LIST_PRICE_SG , UNIT_PRICE , UNIT_PRICE_F , UNIT_PRICE_G , UNIT_PRICE_SG , UNIT_PRICE_PERCENT , UBT_AMT , UBT_AMT_F , UBT_AMT_G , UBT_AMT_SG , UBT_AMT_A , SUPP_CREDIT , SUPP_CREDIT_F , SUPP_CREDIT_G , SUPP_CREDIT_SG , SUPP_CREDIT_A , CREDIT_AMT , CREDIT_AMT_F , CREDIT_AMT_G , CREDIT_AMT_SG , CREDIT_AMT_A , OVERRIDE_AMT , OVERRIDE_AMT_F , OVERRIDE_AMT_G , OVERRIDE_AMT_SG , OVERRIDE_AMT_A , PRICE_NEGOTIATED , PRICE_NEGOTIATED_F , PRICE_NEGOTIATED_G , PRICE_NEGOTIATED_SG , PRICE_NEGOTIATED_A , P_UBT_AMT + P_SUPP_CREDIT + P_CREDIT_AMT + P_PRICE_NEGOTIATED RENEWED_PRICE , P_UBT_AMT_F + P_SUPP_CREDIT_F + P_CREDIT_AMT_F + P_PRICE_NEGOTIATED_F RENEWED_PRICE_F , P_UBT_AMT_G + P_SUPP_CREDIT_G + P_CREDIT_AMT_G + P_PRICE_NEGOTIATED_G RENEWED_PRICE_G , P_UBT_AMT_SG + P_SUPP_CREDIT_SG + P_CREDIT_AMT_SG + P_PRICE_NEGOTIATED_SG RENEWED_PRICE_SG , P_UBT_AMT_A + P_SUPP_CREDIT_A + P_CREDIT_AMT_A + P_PRICE_NEGOTIATED_A RENEWED_PRICE_A , LINE_TYPE , TRX_FUNC_CURR_RATE , FUNC_GLOBAL_CURR_RATE , FUNC_SGLOBAL_CURR_RATE , AGREEMENT_TYPE_CODE , AGREEMENT_NAME , SL_TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE FROM OKI_DBI_CLE_B , ( SELECT CURR_CODE_G , CURR_CODE_SG , DECODE( BIS_COMMON_PARAMETERS.GET_ANNUALIZED_CURRENCY_CODE, 'PRIMARY', CURR_CODE_G, 'SECONDARY', CURR_CODE_SG, CURR_CODE_G ) CURR_CODE_A FROM(SELECT CAST( BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE AS VARCHAR2(15)) CURR_CODE_G , CAST( BIS_COMMON_PARAMETERS.GET_SECONDARY_CURRENCY_CODE AS VARCHAR2(15)) CURR_CODE_SG FROM DUAL)) CURR WHERE application_id = 515 AND buy_or_sell = 'S' AND gsd_flag = 1 AND term_flag = 1 AND scs_code IN ('SERVICE','WARRANTY') AND root_lty_code IN ('SERVICE','WARRANTY','EXT_WARRANTY') AND OKC_UTIL.GET_K_ACCESS_LEVEL( CHR_ID, SCS_CODE ) IN( 'R', 'U' )

View Text - HTML Formatted

SELECT CHR_ID
, CLE_ID
, COV_PROD_ID
, COV_PROD_SYSTEM_ID
, COVERED_ITEM_ID
, SERVICE_ITEM_ID
, INV_ORGANIZATION_ID
, SLE_ID
, P_CHR_ID
, P_CLE_ID
, SCS_CODE
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, CONTRACT_NUMBER || DECODE( CONTRACT_NUMBER_MODIFIER
, NULL
, NULL
, ' ' || CONTRACT_NUMBER_MODIFIER ) COMPLETE_K_NUMBER
, LINE_NUMBER
, STS_CODE
, TRN_CODE
, ORDER_NUMBER
, CLE_CREATION_DATE
, TRUNC(DATE_CANCELLED) DATE_CANCELLED
, TRUNC(DATE_TERMINATED) DATE_TERMINATED
, TRUNC(END_DATE - 1) END_DATE
, TRUNC(START_DATE) START_DATE
, CL_LAST_UPDATE_DATE LAST_UPDATE_DATE
, RENEWAL_FLAG
, RENEWAL_TYPE RENEWAL_TYPE_CODE
, DURATION_QTY
, DURATION_UOM
, QUANTITY
, UOM_CODE
, CURR_CODE
, CURR_CODE_F
, CURR_CODE_G
, CURR_CODE_SG
, CURR_CODE_A
, LIST_PRICE
, LIST_PRICE_F
, LIST_PRICE_G
, LIST_PRICE_SG
, UNIT_PRICE
, UNIT_PRICE_F
, UNIT_PRICE_G
, UNIT_PRICE_SG
, UNIT_PRICE_PERCENT
, UBT_AMT
, UBT_AMT_F
, UBT_AMT_G
, UBT_AMT_SG
, UBT_AMT_A
, SUPP_CREDIT
, SUPP_CREDIT_F
, SUPP_CREDIT_G
, SUPP_CREDIT_SG
, SUPP_CREDIT_A
, CREDIT_AMT
, CREDIT_AMT_F
, CREDIT_AMT_G
, CREDIT_AMT_SG
, CREDIT_AMT_A
, OVERRIDE_AMT
, OVERRIDE_AMT_F
, OVERRIDE_AMT_G
, OVERRIDE_AMT_SG
, OVERRIDE_AMT_A
, PRICE_NEGOTIATED
, PRICE_NEGOTIATED_F
, PRICE_NEGOTIATED_G
, PRICE_NEGOTIATED_SG
, PRICE_NEGOTIATED_A
, P_UBT_AMT + P_SUPP_CREDIT + P_CREDIT_AMT + P_PRICE_NEGOTIATED RENEWED_PRICE
, P_UBT_AMT_F + P_SUPP_CREDIT_F + P_CREDIT_AMT_F + P_PRICE_NEGOTIATED_F RENEWED_PRICE_F
, P_UBT_AMT_G + P_SUPP_CREDIT_G + P_CREDIT_AMT_G + P_PRICE_NEGOTIATED_G RENEWED_PRICE_G
, P_UBT_AMT_SG + P_SUPP_CREDIT_SG + P_CREDIT_AMT_SG + P_PRICE_NEGOTIATED_SG RENEWED_PRICE_SG
, P_UBT_AMT_A + P_SUPP_CREDIT_A + P_CREDIT_AMT_A + P_PRICE_NEGOTIATED_A RENEWED_PRICE_A
, LINE_TYPE
, TRX_FUNC_CURR_RATE
, FUNC_GLOBAL_CURR_RATE
, FUNC_SGLOBAL_CURR_RATE
, AGREEMENT_TYPE_CODE
, AGREEMENT_NAME
, SL_TERM_CANCEL_SOURCE TERM_CANCEL_SOURCE
FROM OKI_DBI_CLE_B
, ( SELECT CURR_CODE_G
, CURR_CODE_SG
, DECODE( BIS_COMMON_PARAMETERS.GET_ANNUALIZED_CURRENCY_CODE
, 'PRIMARY'
, CURR_CODE_G
, 'SECONDARY'
, CURR_CODE_SG
, CURR_CODE_G ) CURR_CODE_A FROM(SELECT CAST( BIS_COMMON_PARAMETERS.GET_CURRENCY_CODE AS VARCHAR2(15)) CURR_CODE_G
, CAST( BIS_COMMON_PARAMETERS.GET_SECONDARY_CURRENCY_CODE AS VARCHAR2(15)) CURR_CODE_SG
FROM DUAL)) CURR
WHERE APPLICATION_ID = 515
AND BUY_OR_SELL = 'S'
AND GSD_FLAG = 1
AND TERM_FLAG = 1
AND SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND ROOT_LTY_CODE IN ('SERVICE'
, 'WARRANTY'
, 'EXT_WARRANTY')
AND OKC_UTIL.GET_K_ACCESS_LEVEL( CHR_ID
, SCS_CODE ) IN( 'R'
, 'U' )