VIEW: APPS.PABV_CUSTOMER_AGREEMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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