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: |
![]() |
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