Product: | QP - Advanced Pricing |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.OE_AGREEMENTS_V |
SELECT AGR.AGREEMENT_ID
, AGR.NAME
, AGR.AGREEMENT_TYPE_CODE
, AGR.PRICE_LIST_ID
, AGR.TERM_ID PAYMENT_TERM_ID
, AGR.OVERRIDE_IRULE_FLAG
, AGR.OVERRIDE_ARULE_FLAG
, AGR.SIGNATURE_DATE
, AGR.AGREEMENT_NUM
, AGR.INVOICING_RULE_ID
, AGR.ACCOUNTING_RULE_ID
, AGR.PURCHASE_ORDER_NUM CUST_PO_NUMBER
, AGR.INVOICE_CONTACT_ID INVOICE_TO_CONTACT_ID
, AGR.AGREEMENT_CONTACT_ID
, AGR.SALESREP_ID
, AGR.START_DATE_ACTIVE
, AGR.END_DATE_ACTIVE
, AGR.CONTEXT
, AGR.ATTRIBUTE1
, AGR.ATTRIBUTE2
, AGR.ATTRIBUTE3
, AGR.ATTRIBUTE4
, AGR.ATTRIBUTE5
, AGR.ATTRIBUTE6
, AGR.ATTRIBUTE7
, AGR.ATTRIBUTE8
, AGR.ATTRIBUTE9
, AGR.ATTRIBUTE10
, AGR.ATTRIBUTE11
, AGR.ATTRIBUTE12
, AGR.ATTRIBUTE13
, AGR.ATTRIBUTE14
, AGR.ATTRIBUTE15
, AGR.LAST_UPDATE_DATE
, AGR.LAST_UPDATED_BY
, AGR.LAST_UPDATE_LOGIN
, AGR.CREATED_BY
, AGR.CREATION_DATE
, AGR. SOLD_TO_ORG_ID
, AGR. INVOICE_TO_ORG_ID
, AGR.SHIP_METHOD_CODE
, AGR.FREIGHT_TERMS_CODE
, AGR.AGREEMENT_SOURCE_CODE
, AGR.ORIG_SYSTEM_AGR_ID
, AGR.DESCRIPTION FROM OE_AGREEMENTS AGR