View: CS_CP_AGREEMENTS_RG_V

Product:	CS - Service
Description:	List of agreements pertaining t oeach party
Implementation/DBA Data:	APPS.CS_CP_AGREEMENTS_RG_V

View Text

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(+)

Columns