VIEW: APPS.OE_AGREEMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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