VIEW: APPS.FII_AR_CUST_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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