View: FII_AR_CUST_LOV_V

Product:	FII - Financial Intelligence
Description:	This view contains the Party Hierarchy and Customer Account Number(s) for the FII view of Customer Dimension.
Implementation/DBA Data:	APPS.FII_AR_CUST_LOV_V

View Text

SELECT NEXT_LEVEL_PARTY_ID ID
, CHIL.PARTY_NAME VALUE
, NVL(PARENT.PARTY_NAME
, '-') PARENT_VALUE FROM HZ_PARTIES CHIL
, HZ_PARTIES PARENT
, (SELECT PARENT_PARTY_ID
, NEXT_LEVEL_PARTY_ID
FROM FII_CUSTOMER_HIERARCHIES
WHERE NEXT_LEVEL_PARTY_ID= CHILD_PARTY_ID
AND PARENT_PARTY_ID <> CHILD_PARTY_ID) WHERE CHIL.PARTY_ID= NEXT_LEVEL_PARTY_ID AND PARENT_PARTY_ID = PARENT.PARTY_ID(+) UNION ALL SELECT -2 ID
, FND_MESSAGE.GET_STRING('FII'
, 'FII_AR_UNID_CUSTOMER') VALUE
, '-' PARENT_VALUE FROM DUAL

Columns