View: OEBV_CUSTOMER_AGREEMENTS

Product:	ONT - Order Management
Description:	Base BIS Business View for Customer Agreements.
Implementation/DBA Data:	APPS.OEBV_CUSTOMER_AGREEMENTS

View Text

SELECT AGREEMENT.AGREEMENT_NUM
, T.NAME
, '_LA:AGREEMENT.AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING'
, '_LA:OVERRIDE_ARULE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:OVERRIDE_IRULE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, AGREEMENT.START_DATE_ACTIVE
, AGREEMENT.END_DATE_ACTIVE
, AGREEMENT.SIGNATURE_DATE
, AGREEMENT.PURCHASE_ORDER_NUM
, '_DF:QP:OE_AGREEMENTS:AGREEMENT'
, AGREEMENT.AGREEMENT_ID
, AGREEMENT.SOLD_TO_ORG_ID
, AGREEMENT.INVOICE_CONTACT_ID
, AGREEMENT.AGREEMENT_CONTACT_ID
, AGREEMENT.INVOICING_RULE_ID
, AGREEMENT.ACCOUNTING_RULE_ID
, AGREEMENT.INVOICE_TO_ORG_ID
, SITE.CUST_ACCT_SITE_ID
, AGREEMENT.SALESREP_ID
, AGREEMENT.TERM_ID
, AGREEMENT.PRICE_LIST_ID
, AGREEMENT.LAST_UPDATE_DATE
, AGREEMENT.LAST_UPDATED_BY
, AGREEMENT.CREATION_DATE
, AGREEMENT.CREATED_BY
, AGREEMENT.REVISION
FROM OE_AGREEMENTS_B AGREEMENT
, OE_AGREEMENTS_TL T
, HZ_CUST_SITE_USES_ALL SITE
WHERE AGREEMENT.INVOICE_TO_ORG_ID = SITE.SITE_USE_ID(+)
AND AGREEMENT.AGREEMENT_ID = T.AGREEMENT_ID
AND T.LANGUAGE = USERENV('LANG')
AND '_SEC:AGREEMENT.SOLD_TO_ORG_ID' IS NOT NULL WITH READ ONLY

Columns