Product: | BIC - Customer Intelligence(Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT C.ORG_ID
, C.CONTRACT_ID
, C.CONTRACT_NUMBER
, C.SHORT_DESCRIPTION
, C.CONTRACT_AMOUNT
, C.CONTRACT_STATUS_CODE
, C.CONTRACT_TYPE_CODE
, C.PARTY_ID
, C.CONTRACT_TEMPLATE_YN
, C.CONTRACT_TEMPLATE_USED
, C.DURATION
, C.PERIOD_CODE
, C.START_DATE_ACTIVE
, C.END_DATE_ACTIVE
, C.BILL_TO_SITE_USE_ID
, C.SHIP_TO_SITE_USE_ID
, C.AGREEMENT_ID
, C.PRICE_LIST_ID
, C.MODIFIER
, C.CURRENCY_CODE
, C.ACCOUNTING_RULE_ID
, C.INVOICING_RULE_ID
, C.TERMS_ID
, C.PO_NUMBER
, C.BILLING_PROFILE_ID
, C.BILLING_FREQUENCY
, C.BILLING_METHOD
, C.REGULAR_OFFSET_DAYS
, C.FIRST_BILL_TO
, C.FIRST_BILL_ON
, C.AUTO_RENEW_BEFORE_DAYS
, C.QA_CHECK_LIST_ID
, C.RENEWAL_NOTE
, C.TERMINATION_NOTE
, C.TAX_EXEMPTION
, C.TAX_STATUS
, C.CONVERSION_TYPE
, R1.NAME ACCOUNTING_RULE
, R2.NAME INVOICING_RULE
, P.NAME PRICE_LIST
, T.NAME PAYMENT_TERMS
, A.NAME AGREEMENT
FROM OKS_ENT_HEADERS_V C
, RA_RULES R1
, RA_RULES R2
, RA_TERMS T
, ASO_I_PRICE_LISTS_V P
, ASO_I_AGREEMENTS_V A
WHERE C.ACCOUNTING_RULE_ID = R1.RULE_ID(+)
AND C.INVOICING_RULE_ID = R2.RULE_ID (+)
AND C.TERMS_ID = T.TERM_ID (+)
AND C.PRICE_LIST_ID = P.PRICE_LIST_ID(+)
AND C.AGREEMENT_ID = A.AGREEMENT_ID(+)