VIEW: APPS.OKI_PRICING_RULES_V

Source

View Text - Preformatted

SELECT shd.CONTRACT_NUMBER , shd.CONTRACT_NUMBER_MODIFIER , shd.COMPLETE_CONTRACT_NUMBER , shd.CHR_ID , null CLE_ID , null DNZ_CHR_ID , null rgp_id , agtl.NAME agreement_name , pltl.name price_list , acc_rule.name account_rule , rttl.name payment_term , inv_rule.name invoicing_rule , shd.grace_duration , shd.grace_period_code FROM OKI_SALES_K_HDRS SHD,OE_AGREEMENTS_TL AGTL,QP_LIST_HEADERS_TL PLTL,RA_TERMS_TL RTTL,RA_RULES ACC_RULE,RA_RULES INV_RULE WHERE agtl.agreement_id(+) = shd.agreement_id and agtl.language(+) = userenv('LANG') and pltl.list_header_id(+) = shd.list_header_id and pltl.language(+) = userenv('LANG') and rttl.term_id(+) = shd.payment_term_id and rttl.language(+) = userenv('LANG') and acc_rule.rule_id(+) = shd.acct_rule_id and inv_rule.rule_id(+) = shd.inv_rule_id

View Text - HTML Formatted

SELECT SHD.CONTRACT_NUMBER
, SHD.CONTRACT_NUMBER_MODIFIER
, SHD.COMPLETE_CONTRACT_NUMBER
, SHD.CHR_ID
, NULL CLE_ID
, NULL DNZ_CHR_ID
, NULL RGP_ID
, AGTL.NAME AGREEMENT_NAME
, PLTL.NAME PRICE_LIST
, ACC_RULE.NAME ACCOUNT_RULE
, RTTL.NAME PAYMENT_TERM
, INV_RULE.NAME INVOICING_RULE
, SHD.GRACE_DURATION
, SHD.GRACE_PERIOD_CODE
FROM OKI_SALES_K_HDRS SHD
, OE_AGREEMENTS_TL AGTL
, QP_LIST_HEADERS_TL PLTL
, RA_TERMS_TL RTTL
, RA_RULES ACC_RULE
, RA_RULES INV_RULE
WHERE AGTL.AGREEMENT_ID(+) = SHD.AGREEMENT_ID
AND AGTL.LANGUAGE(+) = USERENV('LANG')
AND PLTL.LIST_HEADER_ID(+) = SHD.LIST_HEADER_ID
AND PLTL.LANGUAGE(+) = USERENV('LANG')
AND RTTL.TERM_ID(+) = SHD.PAYMENT_TERM_ID
AND RTTL.LANGUAGE(+) = USERENV('LANG')
AND ACC_RULE.RULE_ID(+) = SHD.ACCT_RULE_ID
AND INV_RULE.RULE_ID(+) = SHD.INV_RULE_ID