View: OEFV_CUSTOMER_AGREEMENTS

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	APPS.OEFV_CUSTOMER_AGREEMENTS

View Text

SELECT AGREEMENT.AGREEMENT_NUM
, AGREEMENT.NAME
, '_LA:AGREEMENT_TYPE_CODE:SO_LOOKUPS:AGREEMENT_TYPE:MEANING'
, '_LA:OVERRIDE_ARULE_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:OVERRIDE_IRULE_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, AGREEMENT.START_DATE_ACTIVE
, AGREEMENT.END_DATE_ACTIVE
, AGREEMENT.SIGNATURE_DATE
, AGREEMENT.PURCHASE_ORDER_NUM
, '_DF:OE:SO_AGREEMENTS:AGREEMENT'
, CUSTOMER.CUSTOMER_NAME
, CONTACT1.FIRST_NAME||' '||CONTACT1.LAST_NAME
, CONTACT2.FIRST_NAME||' '||CONTACT2.LAST_NAME
, RULE1.NAME
, RULE2.NAME
, SITE_USE.LOCATION
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.STATE
, ADDR.POSTAL_CODE
, ADDR.PROVINCE
, ADDR.COUNTY
, ADDR.COUNTRY
, SALESREP.NAME
, TERM.NAME
, PRICE_LIST.NAME
, AGREEMENT.AGREEMENT_ID
, AGREEMENT.INVOICE_CONTACT_ID
, AGREEMENT.AGREEMENT_CONTACT_ID
, AGREEMENT.CUSTOMER_ID
, AGREEMENT.INVOICING_RULE_ID
, AGREEMENT.ACCOUNTING_RULE_ID
, AGREEMENT.SALESREP_ID
, AGREEMENT.INVOICE_TO_SITE_USE_ID
, SITE_USE.ADDRESS_ID
, AGREEMENT.TERM_ID
, AGREEMENT.PRICE_LIST_ID
, AGREEMENT.LAST_UPDATE_DATE
, AGREEMENT.LAST_UPDATED_BY
, AGREEMENT.CREATION_DATE
, AGREEMENT.CREATED_BY
FROM SO_AGREEMENTS AGREEMENT
, RA_CONTACTS CONTACT1
, RA_CONTACTS CONTACT2
, RA_CUSTOMERS CUSTOMER
, RA_RULES RULE1
, RA_RULES RULE2
, RA_SALESREPS_ALL SALESREP
, RA_SITE_USES_ALL SITE_USE
, RA_ADDRESSES_ALL ADDR
, RA_TERMS TERM
, SO_PRICE_LISTS PRICE_LIST
WHERE AGREEMENT.INVOICE_CONTACT_ID = CONTACT1.CONTACT_ID(+)
AND AGREEMENT.AGREEMENT_CONTACT_ID = CONTACT2.CONTACT_ID(+)
AND AGREEMENT.CUSTOMER_ID = CUSTOMER.CUSTOMER_ID(+)
AND AGREEMENT.INVOICING_RULE_ID = RULE1.RULE_ID(+)
AND AGREEMENT.ACCOUNTING_RULE_ID = RULE2.RULE_ID(+)
AND AGREEMENT.SALESREP_ID = SALESREP.SALESREP_ID(+)
AND AGREEMENT.INVOICE_TO_SITE_USE_ID = SITE_USE.SITE_USE_ID(+)
AND SITE_USE.ADDRESS_ID = ADDR.ADDRESS_ID(+)
AND AGREEMENT.TERM_ID = TERM.TERM_ID
AND AGREEMENT.PRICE_LIST_ID = PRICE_LIST.PRICE_LIST_ID WITH READ ONLY

Columns