VIEW: APPS.FII_AR_SUMMARY_GT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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