VIEW: APPS.PAFV_CUSTOMER_AGREEMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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