VIEW: APPS.OKI_SRM_006_V

Source

View Text - Preformatted

SELECT chr_id , contract_number , contract_number_modifier , complete_k_number , customer_party_id , salesrep_id , authoring_org_id , rg_id resource_group_id , resource_id resource_id , scs_code , sts_code , trn_code , renewal_type_code , order_number , curr_code , curr_code_f , curr_code_g , curr_code_sg , curr_code_a , win_percent , expected_close_date , date_cancelled , date_signed , start_date , end_date , grace_end_date , date_approved , date_terminated , creation_date , last_update_date , bill_site_id , ship_site_id , acct_rule_id , subsequent_renewal_type_code , negotiation_status , reminder , 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_a , price_nego_g , price_nego_sg FROM OKI_SRM_006_MV V , ( 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 CHR_ID
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, COMPLETE_K_NUMBER
, CUSTOMER_PARTY_ID
, SALESREP_ID
, AUTHORING_ORG_ID
, RG_ID RESOURCE_GROUP_ID
, RESOURCE_ID RESOURCE_ID
, SCS_CODE
, STS_CODE
, TRN_CODE
, RENEWAL_TYPE_CODE
, ORDER_NUMBER
, CURR_CODE
, CURR_CODE_F
, CURR_CODE_G
, CURR_CODE_SG
, CURR_CODE_A
, WIN_PERCENT
, EXPECTED_CLOSE_DATE
, DATE_CANCELLED
, DATE_SIGNED
, START_DATE
, END_DATE
, GRACE_END_DATE
, DATE_APPROVED
, DATE_TERMINATED
, CREATION_DATE
, LAST_UPDATE_DATE
, BILL_SITE_ID
, SHIP_SITE_ID
, ACCT_RULE_ID
, SUBSEQUENT_RENEWAL_TYPE_CODE
, NEGOTIATION_STATUS
, REMINDER
, 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_A
, PRICE_NEGO_G
, PRICE_NEGO_SG
FROM OKI_SRM_006_MV V
, ( 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' )