VIEW: APPS.OEBV_CUSTOMER_AGREEMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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