Product: | FII - Financial Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FII_AR_NET_REC_BASE_MV_F_V |
SELECT TIME_ID
, PERIOD_TYPE_ID
, PARENT_PARTY_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, COLLECTOR_ID
, ORG_ID
, CLASS_CODE
, CLASS_CATEGORY
, HEADER_FILTER_DATE
, CURRENT_BUCKET_1_AMOUNT_FUNC
, CURRENT_BUCKET_1_COUNT
, CURRENT_BUCKET_2_AMOUNT_FUNC
, CURRENT_BUCKET_2_COUNT
, CURRENT_BUCKET_3_AMOUNT_FUNC
, CURRENT_BUCKET_3_COUNT
, PAST_DUE_BUCKET_1_AMOUNT_FUNC
, PAST_DUE_BUCKET_1_COUNT
, PAST_DUE_BUCKET_2_AMOUNT_FUNC
, PAST_DUE_BUCKET_2_COUNT
, PAST_DUE_BUCKET_3_AMOUNT_FUNC
, PAST_DUE_BUCKET_3_COUNT
, PAST_DUE_BUCKET_4_AMOUNT_FUNC
, PAST_DUE_BUCKET_4_COUNT
, PAST_DUE_BUCKET_5_AMOUNT_FUNC
, PAST_DUE_BUCKET_5_COUNT
, PAST_DUE_BUCKET_6_AMOUNT_FUNC
, PAST_DUE_BUCKET_6_COUNT
, PAST_DUE_BUCKET_7_AMOUNT_FUNC
, PAST_DUE_BUCKET_7_COUNT
, CURRENT_OPEN_AMOUNT_FUNC
, CURRENT_OPEN_COUNT
, PAST_DUE_OPEN_AMOUNT_FUNC
, PAST_DUE_COUNT
, WTD_TERMS_OUT_OPEN_NUM_FUNC
, WTD_TERMS_OUT_CURRENT_NUM_FUNC
, WTD_DDSO_DUE_NUM_FUNC
, TOTAL_OPEN_AMOUNT_FUNC
, TOTAL_OPEN_COUNT
, INV_AMOUNT_FUNC
, DM_AMOUNT_FUNC
, CB_AMOUNT_FUNC
, BR_AMOUNT_FUNC
, DEP_AMOUNT_FUNC
, ON_ACCOUNT_CREDIT_AMOUNT_FUNC
, UNAPP_DEP_AMOUNT_FUNC
, APP_AMOUNT_FUNC
, APP_COUNT
, ON_ACCOUNT_CASH_AMOUNT_FUNC
, PREPAYMENT_AMOUNT_FUNC
, CLAIM_AMOUNT_FUNC
, REV_AMOUNT_FUNC
, REV_COUNT
, TOTAL_RECEIPT_AMOUNT_FUNC
, TOTAL_RECEIPT_COUNT
, EARNED_DISCOUNT_AMOUNT_FUNC
, UNEARNED_DISCOUNT_AMOUNT_FUNC
, AVG_DD_NUM_FUNC
, WTD_DAYS_PAID_NUM_FUNC
, WTD_TERMS_PAID_NUM_FUNC
, BILLED_AMOUNT_FUNC
, BILLING_ACTIVITY_AMOUNT_FUNC
, BILLING_ACTIVITY_COUNT
, GID
, UMARKER
FROM FII_AR_NET_REC_BASE_MV