VIEW: APPS.OKI_SRM_005_V

Source

View Text - Preformatted

SELECT SLE_ID, CHR_ID, CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER, COMPLETE_K_NUMBER, LINE_NUMBER, STS_CODE, TRN_CODE, RENEWAL_TYPE_CODE, DATE_CANCELLED, START_DATE, END_DATE, DATE_TERMINATED, CREATION_DATE, LAST_UPDATE_DATE, CURR_CODE, CURR_CODE_F, CURR_CODE_G, CURR_CODE_SG, CURR_CODE_A, ITEM_CATEGORY_ID, ITEM_ID, INV_ORG_ID, AUTHORING_ORG_ID, TRX_FUNC_CURR_RATE, FUNC_GLOBAL_CURR_RATE, FUNC_SGLOBAL_CURR_RATE, TERM_CANCEL_SOURCE, 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_NEGO, PRICE_NEGO_F, PRICE_NEGO_G, PRICE_NEGO_SG, PRICE_NEGO_A FROM OKI_SRM_005_MV, (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 OKC_UTIL.GET_K_ACCESS_LEVEL( CHR_ID, SCS_CODE ) IN( 'R', 'U' )

View Text - HTML Formatted

SELECT SLE_ID
, CHR_ID
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, COMPLETE_K_NUMBER
, LINE_NUMBER
, STS_CODE
, TRN_CODE
, RENEWAL_TYPE_CODE
, DATE_CANCELLED
, START_DATE
, END_DATE
, DATE_TERMINATED
, CREATION_DATE
, LAST_UPDATE_DATE
, CURR_CODE
, CURR_CODE_F
, CURR_CODE_G
, CURR_CODE_SG
, CURR_CODE_A
, ITEM_CATEGORY_ID
, ITEM_ID
, INV_ORG_ID
, AUTHORING_ORG_ID
, TRX_FUNC_CURR_RATE
, FUNC_GLOBAL_CURR_RATE
, FUNC_SGLOBAL_CURR_RATE
, TERM_CANCEL_SOURCE
, 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_NEGO
, PRICE_NEGO_F
, PRICE_NEGO_G
, PRICE_NEGO_SG
, PRICE_NEGO_A
FROM OKI_SRM_005_MV
, (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 OKC_UTIL.GET_K_ACCESS_LEVEL( CHR_ID
, SCS_CODE ) IN( 'R'
, 'U' )