View: QPBV_AGREEMENTS

Product:	QP - Advanced Pricing
Description:	This view gives information about the agreements.
Implementation/DBA Data:	APPS.QPBV_AGREEMENTS

View Text

SELECT AG. NAME
, AG.PRICE_LIST_ID
, AG.TERM_ID
, AG.OVERRIDE_IRULE_FLAG
, AG.OVERRIDE_ARULE_FLAG
, AG.SIGNATURE_DATE
, AG.AGREEMENT_NUM
, AG.REVISION
, AG.REVISION_DATE
, AG.INVOICING_RULE_ID
, AG.ACCOUNTING_RULE_ID
, AG.PURCHASE_ORDER_NUM
, AG.INVOICE_CONTACT_ID
, AG.AGREEMENT_CONTACT_ID
, AG.SALESREP_ID
, AG.START_DATE_ACTIVE
, AG.END_DATE_ACTIVE
, AG.TP_ATTRIBUTE_CATEGORY
, AG.INVOICE_TO_ORG_ID
, AG.SOLD_TO_ORG_ID
, TL. NAME
, AG.REVISION_REASON_CODE
, AG.FREIGHT_TERMS_CODE
, AG.SHIP_METHOD_CODE
, AG.AGREEMENT_TYPE_CODE
, AG.AGREEMENT_ID
, AG.CREATION_DATE
, AG.CREATED_BY
, AG.LAST_UPDATE_DATE
, AG.LAST_UPDATED_BY
FROM OE_AGREEMENTS_B AG
, OE_AGREEMENTS_TL TL
WHERE AG.AGREEMENT_ID = TL.AGREEMENT_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns