[Home] [Help]
View: 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
Name |
PARENT_PARTY_ID |
PARTY_ID |
CUST_ACCOUNT_ID |
ORG_ID |
COLLECTOR_ID |
IS_LEAF_FLAG |
CLASS_CODE |
CLASS_CATEGORY |
VIEWBY |
VIEWBY_CODE |