View: FII_AR_SUMMARY_GT_V

Product:	FII - Financial Intelligence
Description:
Implementation/DBA Data:	APPS.FII_AR_SUMMARY_GT_V

View Text

SELECT NULL PARENT_PARTY_ID
, ACC.ACCOUNT_OWNER_PARTY_ID PARTY_ID
, ACC.CUST_ACCOUNT_ID
, GT.ORG_ID
, GT.COLLECTOR_ID
, GT.IS_LEAF_FLAG
, GT.CLASS_CODE
, GT.CLASS_CATEGORY
, DECODE(GT.PARTY_ID
, -2
, FND_MESSAGE.GET_STRING('FII'
, 'FII_AR_UNID_CUSTOMER')
, HZ.PARTY_NAME||' ('||HZA.ACCOUNT_NUMBER||')') VIEWBY
, ACC.CUST_ACCOUNT_ID VIEWBY_CODE
FROM FII_AR_SUMMARY_GT GT
, FII_CUST_ACCOUNTS ACC
, HZ_PARTIES HZ
, HZ_CUST_ACCOUNTS HZA
WHERE GT.PARTY_ID = ACC.PARENT_PARTY_ID
AND ACC.ACCOUNT_OWNER_PARTY_ID = HZ.PARTY_ID (+)
AND ACC.CUST_ACCOUNT_ID = HZA.CUST_ACCOUNT_ID (+)
AND ACC.ACCOUNT_OWNER_PARTY_ID = ACC.PARENT_PARTY_ID

Columns