FND Design Data [Home] [Help]

View: PABV_CUSTOMER_AGREEMENTS

Product: PA - Projects
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.PABV_CUSTOMER_AGREEMENTS
View Text

SELECT PA.AGREEMENT_ID
, PA.AGREEMENT_NUM
, PA.DESCRIPTION
, PA.AMOUNT
, PA.EXPIRATION_DATE
, '_LA:REVENUE_LIMIT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:TEMPLATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:PA:PA_AGREEMENTS_DESC_FLEX:PA'
, PA.OWNED_BY_PERSON_ID
, PA.TERM_ID
, PA.AGREEMENT_TYPE
, PA.CUSTOMER_ID
, PA.ORG_ID
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.CREATION_DATE
, PA.CREATED_BY
FROM PA_AGREEMENTS_ALL PA
WHERE '_SEC:PA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
AGREEMENT_ID
AGREEMENT_NUMBER
DESCRIPTION
AMOUNT
EXPIRATION_DATE
"_LA:REVENUE_LIMIT_FLAG"
"_LA:TEMPLATE_FLAG"
"_DF"
OWNED_BY_PERSON_ID
TERM_ID
AGREEMENT_TYPE
CUSTOMER_ID
ORG_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY