FND Design Data [Home] [Help]

View: PAFV_CUSTOMER_AGREEMENT_TYPES

Product: PA - Projects
Description: Business view to show information about the various customer agreements possible
Implementation/DBA Data: ViewAPPS.PAFV_CUSTOMER_AGREEMENT_TYPES
View Text

SELECT PAT.AGREEMENT_TYPE
, '_LA:REVENUE_LIMIT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:PA:PA_AGREEMENT_TYPE_DESC_FLEX:PAT'
, PAT.START_DATE_ACTIVE
, PAT.END_DATE_ACTIVE
, PAT.DESCRIPTION
, PAT.LAST_UPDATE_DATE
, PAT.LAST_UPDATED_BY
, PAT.CREATION_DATE
, PAT.CREATED_BY
FROM PA_AGREEMENT_TYPES PAT WITH READ ONLY

Columns

Name
AGREEMENT_TYPE
"_LA:REVENUE_LIMIT_FLAG"
"_DF"
START_EFFECTIVE_DATE
END_EFFECTIVE_DATE
DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY