FND Design Data [Home] [Help]

View: PA_AGREEMENTS_AMG_V

Product: PA - Projects
Description: This Single-Org view based on PA_AGREEMENTS_ALL table, stores information about legally binding documents from customers that serve as the basis of work authorization for projects
Implementation/DBA Data: ViewAPPS.PA_AGREEMENTS_AMG_V
View Text

SELECT AGREEMENT_ID
, CUSTOMER_ID
, AGREEMENT_NUM
, AGREEMENT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OWNED_BY_PERSON_ID
, TERM_ID
, REVENUE_LIMIT_FLAG
, AMOUNT
, DESCRIPTION
, EXPIRATION_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, TEMPLATE_FLAG
, ORG_ID
, PM_AGREEMENT_REFERENCE
, PM_PRODUCT_CODE
, OWNING_ORGANIZATION_ID
, AGREEMENT_CURRENCY_CODE
, INVOICE_LIMIT_FLAG
FROM PA_AGREEMENTS

Columns

Name
AGREEMENT_ID
CUSTOMER_ID
AGREEMENT_NUM
AGREEMENT_TYPE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OWNED_BY_PERSON_ID
TERM_ID
REVENUE_LIMIT_FLAG
AMOUNT
DESCRIPTION
EXPIRATION_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
TEMPLATE_FLAG
ORG_ID
PM_AGREEMENT_REFERENCE
PM_PRODUCT_CODE
OWNING_ORGANIZATION_ID
AGREEMENT_CURRENCY_CODE
INVOICE_LIMIT_FLAG