Product: | PA - Projects |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: |
![]() |
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