eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: SO_AGREEMENTS_VL

Product:	OE - Order Entry
Description:
Implementation/DBA Data:	APPS.SO_AGREEMENTS_VL

View Text

SELECT B.ROWID ROW_ID
, B.END_DATE_ACTIVE
, B.CONTEXT
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.AGREEMENT_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.AGREEMENT_TYPE_CODE
, B.PRICE_LIST_ID
, B.TERM_ID
, B.OVERRIDE_IRULE_FLAG
, B.OVERRIDE_ARULE_FLAG
, B.SIGNATURE_DATE
, B.AGREEMENT_NUM
, B.INVOICING_RULE_ID
, B.ACCOUNTING_RULE_ID
, B.CUSTOMER_ID
, B.PURCHASE_ORDER_NUM
, B.INVOICE_CONTACT_ID
, B.AGREEMENT_CONTACT_ID
, B.INVOICE_TO_SITE_USE_ID
, B.SALESREP_ID
, B.START_DATE_ACTIVE
, T.NAME
FROM SO_AGREEMENTS_TL T
, SO_AGREEMENTS_B B
WHERE B.AGREEMENT_ID = T.AGREEMENT_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
END_DATE_ACTIVE
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
AGREEMENT_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
AGREEMENT_TYPE_CODE
PRICE_LIST_ID
TERM_ID
OVERRIDE_IRULE_FLAG
OVERRIDE_ARULE_FLAG
SIGNATURE_DATE
AGREEMENT_NUM
INVOICING_RULE_ID
ACCOUNTING_RULE_ID
CUSTOMER_ID
PURCHASE_ORDER_NUM
INVOICE_CONTACT_ID
AGREEMENT_CONTACT_ID
INVOICE_TO_SITE_USE_ID
SALESREP_ID
START_DATE_ACTIVE
NAME