DBA Data[Home] [Help]

VIEW: APPS.FII_AR_RCT_AGING_AGRT_MV_S_V

Source

View Text - Preformatted

SELECT TIME_ID, PERIOD_TYPE_ID, PARENT_PARTY_ID, PARTY_ID, CUST_ACCOUNT_ID, COLLECTOR_ID, ORG_ID, AGING_BUCKET_1_AMOUNT_SEC, AGING_BUCKET_1_COUNT, AGING_BUCKET_2_AMOUNT_SEC, AGING_BUCKET_2_COUNT, AGING_BUCKET_3_AMOUNT_SEC, AGING_BUCKET_3_COUNT, UNID_AMOUNT_SEC, UNAPP_AMOUNT_SEC, TOTAL_UNAPPLIED_AMOUNT_SEC, TOTAL_UNAPPLIED_COUNT,GID from fii_ar_rct_aging_agrt_mv
View Text - HTML Formatted

SELECT TIME_ID
, PERIOD_TYPE_ID
, PARENT_PARTY_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, COLLECTOR_ID
, ORG_ID
, AGING_BUCKET_1_AMOUNT_SEC
, AGING_BUCKET_1_COUNT
, AGING_BUCKET_2_AMOUNT_SEC
, AGING_BUCKET_2_COUNT
, AGING_BUCKET_3_AMOUNT_SEC
, AGING_BUCKET_3_COUNT
, UNID_AMOUNT_SEC
, UNAPP_AMOUNT_SEC
, TOTAL_UNAPPLIED_AMOUNT_SEC
, TOTAL_UNAPPLIED_COUNT
, GID
FROM FII_AR_RCT_AGING_AGRT_MV