VIEW: APPS.CS_CP_AGREEMENTS_RG_V

Source

View Text - Preformatted

SELECT a.agreement_id, a.name Agreement_name, a.agreement_num agreement_number, b.cust_account_id, c.party_name party_name, c.party_number, b.account_number from hz_parties c, hz_cust_accounts b , aso_i_Agreements_v a where a.sold_to_org_id = b.cust_account_id(+) and b.party_id = c.party_id(+)

View Text - HTML Formatted

SELECT A.AGREEMENT_ID
, A.NAME AGREEMENT_NAME
, A.AGREEMENT_NUM AGREEMENT_NUMBER
, B.CUST_ACCOUNT_ID
, C.PARTY_NAME PARTY_NAME
, C.PARTY_NUMBER
, B.ACCOUNT_NUMBER
FROM HZ_PARTIES C
, HZ_CUST_ACCOUNTS B
, ASO_I_AGREEMENTS_V A
WHERE A.SOLD_TO_ORG_ID = B.CUST_ACCOUNT_ID(+)
AND B.PARTY_ID = C.PARTY_ID(+)