View: QPFV_AGREEMENTS

Product:	QP - Advanced Pricing
Description:	This view gives information about the agreements.
Implementation/DBA Data:	APPS.QPFV_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
, '_LA:AG.REVISION_REASON_CODE:QP_LOOKUPS:QP_REVISION_REASON_CODE:MEANING'
, AG.FREIGHT_TERMS_CODE
, FREIGHT.FREIGHT_TERMS
, AG.SHIP_METHOD_CODE
, SHIP.MEANING
, AG.AGREEMENT_TYPE_CODE
, '_LA:AG.AGREEMENT_TYPE_CODE:QP_LOOKUPS:QP_AGREEMENT_TYPE:MEANING'
, AG.AGREEMENT_ID
, AG.CREATION_DATE
, AG.CREATED_BY
, AG.LAST_UPDATE_DATE
, AG.LAST_UPDATED_BY
, '_DF:QP:OE_AGREEMENTS:AG'
, PARTY.PARTY_NAME CUSTOMER_NAME
, CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
FROM OE_AGREEMENTS_B AG
, OE_AGREEMENTS_TL TL
, OE_SHIP_METHODS_V SHIP
, OE_FRGHT_TERMS_ACTIVE_V FREIGHT
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
WHERE AG.AGREEMENT_ID = TL.AGREEMENT_ID
AND TL.LANGUAGE = USERENV('LANG')
AND AG.SHIP_METHOD_CODE = SHIP.LOOKUP_CODE (+)
AND AG.FREIGHT_TERMS_CODE = FREIGHT.FREIGHT_TERMS_CODE (+)
AND PARTY.PARTY_ID(+) = AG.SOLD_TO_ORG_ID
AND CUST_ACCT.PARTY_ID(+) = PARTY.PARTY_ID
AND CUST_ACCT.STATUS(+) = 'A' WITH READ ONLY

Columns