View: PAFV_CUSTOMER_AGREEMENTS

Product:	PA - Projects
Description:	Business view to show information about the customer agreements.
Implementation/DBA Data:	APPS.PAFV_CUSTOMER_AGREEMENTS

View Text

SELECT PA.AGREEMENT_ID
, PA.AGREEMENT_NUM
, PA.DESCRIPTION
, PA.AMOUNT
, PA.EXPIRATION_DATE
, '_LA:PA.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
, PAP.FULL_NAME
, PA.TERM_ID
, RT.NAME
, PA.AGREEMENT_TYPE
, PAT.DESCRIPTION
, PA.CUSTOMER_ID
, HZ_P.PARTY_NAME
, PA.ORG_ID
, TL.NAME
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.CREATION_DATE
, PA.CREATED_BY
FROM PA_AGREEMENTS_ALL PA
, PA_AGREEMENT_TYPES PAT
, PER_ALL_PEOPLE_F PAP
, HZ_CUST_ACCOUNTS HZ_C
, HZ_PARTIES HZ_P
, RA_TERMS RT
, HR_ALL_ORGANIZATION_UNITS HRO
, HR_ALL_ORGANIZATION_UNITS_TL TL
WHERE PA.AGREEMENT_TYPE = PAT.AGREEMENT_TYPE
AND PA.OWNED_BY_PERSON_ID = PAP.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAP.EFFECTIVE_START_DATE (+)
AND PAP.EFFECTIVE_END_DATE (+)
AND HZ_C.CUST_ACCOUNT_ID = PA.CUSTOMER_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID
AND PA.TERM_ID = RT.TERM_ID(+)
AND '_SEC:PA.ORG_ID' IS NOT NULL
AND PA.ORG_ID=HRO.ORGANIZATION_ID (+)
AND PA.ORG_ID=TL.ORGANIZATION_ID (+)
AND TL.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns