[Home] [Help] [Dependency Information]
Object Name: | FII_AR_NET_REC_INTR_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Container: | FII_AR_NET_REC_INTR_MV |
---|---|
Updatable: | N |
Rewrite Enabled: | N |
Rewrite Capability: | TEXTMATCH |
Refresh Mode: | DEMAND |
Refresh Method: | FAST |
Build Mode: | DEFERRED |
Fast Refreshable: | DIRLOAD_DML |
FII_AR_AGING_RECEIVABLES
FII_AR_DIMENSIONS_MV
FII_AR_SETUP
FII_COLLECTORS
FII_PARTY_MKT_CLASS
FII_AR_RECEIPTS_F
FII_TIME_DAY
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UMARKER | VARCHAR2 | (10) | ||
ENT_YEAR_ID | NUMBER | |||
ENT_QTR_ID | NUMBER | |||
ENT_PERIOD_ID | NUMBER | |||
ENT_WEEK_ID | NUMBER | |||
REPORT_DATE_JULIAN | NUMBER | |||
GID | NUMBER | |||
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
PARENT_PARTY_ID | NUMBER | |||
PARTY_ID | NUMBER | |||
CUST_ACCOUNT_ID | NUMBER | (15) | ||
COLLECTOR_ID | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
CLASS_CODE | VARCHAR2 | (30) | ||
CLASS_CATEGORY | VARCHAR2 | (30) | ||
HEADER_FILTER_DATE | DATE | |||
CURRENT_BUCKET_1_AMOUNT_FUNC | NUMBER | |||
CURRENT_BUCKET_1_AMOUNT_PRIM | NUMBER | |||
CURRENT_BUCKET_1_AMOUNT_SEC | NUMBER | |||
CURRENT_BUCKET_1_COUNT | NUMBER | |||
CURRENT_BUCKET_2_AMOUNT_FUNC | NUMBER | |||
CURRENT_BUCKET_2_AMOUNT_PRIM | NUMBER | |||
CURRENT_BUCKET_2_AMOUNT_SEC | NUMBER | |||
CURRENT_BUCKET_2_COUNT | NUMBER | |||
CURRENT_BUCKET_3_AMOUNT_FUNC | NUMBER | |||
CURRENT_BUCKET_3_AMOUNT_PRIM | NUMBER | |||
CURRENT_BUCKET_3_AMOUNT_SEC | NUMBER | |||
CURRENT_BUCKET_3_COUNT | NUMBER | |||
PAST_DUE_BUCKET_1_AMOUNT_FUNC | NUMBER | |||
PAST_DUE_BUCKET_1_AMOUNT_PRIM | NUMBER | |||
PAST_DUE_BUCKET_1_AMOUNT_SEC | NUMBER | |||
PAST_DUE_BUCKET_1_COUNT | NUMBER | |||
PAST_DUE_BUCKET_2_AMOUNT_FUNC | NUMBER | |||
PAST_DUE_BUCKET_2_AMOUNT_PRIM | NUMBER | |||
PAST_DUE_BUCKET_2_AMOUNT_SEC | NUMBER | |||
PAST_DUE_BUCKET_2_COUNT | NUMBER | |||
PAST_DUE_BUCKET_3_AMOUNT_FUNC | NUMBER | |||
PAST_DUE_BUCKET_3_AMOUNT_PRIM | NUMBER | |||
PAST_DUE_BUCKET_3_AMOUNT_SEC | NUMBER | |||
PAST_DUE_BUCKET_3_COUNT | NUMBER | |||
PAST_DUE_BUCKET_4_AMOUNT_FUNC | NUMBER | |||
PAST_DUE_BUCKET_4_AMOUNT_PRIM | NUMBER | |||
PAST_DUE_BUCKET_4_AMOUNT_SEC | NUMBER | |||
PAST_DUE_BUCKET_4_COUNT | NUMBER | |||
PAST_DUE_BUCKET_5_AMOUNT_FUNC | NUMBER | |||
PAST_DUE_BUCKET_5_AMOUNT_PRIM | NUMBER | |||
PAST_DUE_BUCKET_5_AMOUNT_SEC | NUMBER | |||
PAST_DUE_BUCKET_5_COUNT | NUMBER | |||
PAST_DUE_BUCKET_6_AMOUNT_FUNC | NUMBER | |||
PAST_DUE_BUCKET_6_AMOUNT_PRIM | NUMBER | |||
PAST_DUE_BUCKET_6_AMOUNT_SEC | NUMBER | |||
PAST_DUE_BUCKET_6_COUNT | NUMBER | |||
PAST_DUE_BUCKET_7_AMOUNT_FUNC | NUMBER | |||
PAST_DUE_BUCKET_7_AMOUNT_PRIM | NUMBER | |||
PAST_DUE_BUCKET_7_AMOUNT_SEC | NUMBER | |||
PAST_DUE_BUCKET_7_COUNT | NUMBER | |||
CURRENT_OPEN_AMOUNT_FUNC | NUMBER | |||
CURRENT_OPEN_AMOUNT_PRIM | NUMBER | |||
CURRENT_OPEN_AMOUNT_SEC | NUMBER | |||
CURRENT_OPEN_COUNT | NUMBER | |||
PAST_DUE_OPEN_AMOUNT_FUNC | NUMBER | |||
PAST_DUE_OPEN_AMOUNT_PRIM | NUMBER | |||
PAST_DUE_OPEN_AMOUNT_SEC | NUMBER | |||
PAST_DUE_COUNT | NUMBER | |||
WTD_TERMS_OUT_OPEN_NUM_FUNC | NUMBER | |||
WTD_TERMS_OUT_OPEN_NUM_PRIM | NUMBER | |||
WTD_TERMS_OUT_OPEN_NUM_SEC | NUMBER | |||
WTD_TERMS_OUT_CURRENT_NUM_FUNC | NUMBER | |||
WTD_TERMS_OUT_CURRENT_NUM_PRIM | NUMBER | |||
WTD_TERMS_OUT_CURRENT_NUM_SEC | NUMBER | |||
WTD_DDSO_DUE_NUM_FUNC | NUMBER | |||
WTD_DDSO_DUE_NUM_PRIM | NUMBER | |||
WTD_DDSO_DUE_NUM_SEC | NUMBER | |||
TOTAL_OPEN_AMOUNT_FUNC | NUMBER | |||
TOTAL_OPEN_AMOUNT_PRIM | NUMBER | |||
TOTAL_OPEN_AMOUNT_SEC | NUMBER | |||
TOTAL_OPEN_COUNT | NUMBER | |||
INV_AMOUNT_FUNC | NUMBER | |||
INV_AMOUNT_PRIM | NUMBER | |||
INV_AMOUNT_SEC | NUMBER | |||
DM_AMOUNT_FUNC | NUMBER | |||
DM_AMOUNT_PRIM | NUMBER | |||
DM_AMOUNT_SEC | NUMBER | |||
CB_AMOUNT_FUNC | NUMBER | |||
CB_AMOUNT_PRIM | NUMBER | |||
CB_AMOUNT_SEC | NUMBER | |||
BR_AMOUNT_FUNC | NUMBER | |||
BR_AMOUNT_PRIM | NUMBER | |||
BR_AMOUNT_SEC | NUMBER | |||
DEP_AMOUNT_FUNC | NUMBER | |||
DEP_AMOUNT_PRIM | NUMBER | |||
DEP_AMOUNT_SEC | NUMBER | |||
ON_ACCOUNT_CREDIT_AMOUNT_FUNC | NUMBER | |||
ON_ACCOUNT_CREDIT_AMOUNT_PRIM | NUMBER | |||
ON_ACCOUNT_CREDIT_AMOUNT_SEC | NUMBER | |||
UNAPP_DEP_AMOUNT_FUNC | NUMBER | |||
UNAPP_DEP_AMOUNT_PRIM | NUMBER | |||
UNAPP_DEP_AMOUNT_SEC | NUMBER | |||
APP_AMOUNT_FUNC | NUMBER | |||
APP_AMOUNT_PRIM | NUMBER | |||
APP_AMOUNT_SEC | NUMBER | |||
APP_COUNT | NUMBER | |||
ON_ACCOUNT_CASH_AMOUNT_FUNC | NUMBER | |||
ON_ACCOUNT_CASH_AMOUNT_PRIM | NUMBER | |||
ON_ACCOUNT_CASH_AMOUNT_SEC | NUMBER | |||
PREPAYMENT_AMOUNT_FUNC | NUMBER | |||
PREPAYMENT_AMOUNT_PRIM | NUMBER | |||
PREPAYMENT_AMOUNT_SEC | NUMBER | |||
CLAIM_AMOUNT_FUNC | NUMBER | |||
CLAIM_AMOUNT_PRIM | NUMBER | |||
CLAIM_AMOUNT_SEC | NUMBER | |||
REV_AMOUNT_FUNC | NUMBER | |||
REV_AMOUNT_PRIM | NUMBER | |||
REV_AMOUNT_SEC | NUMBER | |||
REV_COUNT | NUMBER | |||
TOTAL_RECEIPT_AMOUNT_FUNC | NUMBER | |||
TOTAL_RECEIPT_AMOUNT_PRIM | NUMBER | |||
TOTAL_RECEIPT_AMOUNT_SEC | NUMBER | |||
TOTAL_RECEIPT_COUNT | NUMBER | |||
EARNED_DISCOUNT_AMOUNT_FUNC | NUMBER | |||
EARNED_DISCOUNT_AMOUNT_PRIM | NUMBER | |||
EARNED_DISCOUNT_AMOUNT_SEC | NUMBER | |||
UNEARNED_DISCOUNT_AMOUNT_FUNC | NUMBER | |||
UNEARNED_DISCOUNT_AMOUNT_PRIM | NUMBER | |||
UNEARNED_DISCOUNT_AMOUNT_SEC | NUMBER | |||
AVG_DD_NUM_FUNC | NUMBER | |||
AVG_DD_NUM_PRIM | NUMBER | |||
AVG_DD_NUM_SEC | NUMBER | |||
WTD_DAYS_PAID_NUM_FUNC | NUMBER | |||
WTD_DAYS_PAID_NUM_PRIM | NUMBER | |||
WTD_DAYS_PAID_NUM_SEC | NUMBER | |||
WTD_TERMS_PAID_NUM_FUNC | NUMBER | |||
WTD_TERMS_PAID_NUM_PRIM | NUMBER | |||
WTD_TERMS_PAID_NUM_SEC | NUMBER | |||
BILLED_AMOUNT_FUNC | NUMBER | |||
BILLED_AMOUNT_PRIM | NUMBER | |||
BILLED_AMOUNT_SEC | NUMBER | |||
BILLING_ACTIVITY_AMOUNT_FUNC | NUMBER | |||
BILLING_ACTIVITY_AMOUNT_PRIM | NUMBER | |||
BILLING_ACTIVITY_AMOUNT_SEC | NUMBER | |||
BILLING_ACTIVITY_COUNT | NUMBER | |||
CURRENT_BUCKET_1_AMT_FUNC_CT | NUMBER | |||
CURRENT_BUCKET_1_AMT_PRIM_CT | NUMBER | |||
CURRENT_BUCKET_1_AMT_SEC_CT | NUMBER | |||
CURRENT_BUCKET_1_COUNT_CT | NUMBER | |||
CURRENT_BUCKET_2_AMT_FUNC_CT | NUMBER | |||
CURRENT_BUCKET_2_AMT_PRIM_CT | NUMBER | |||
CURRENT_BUCKET_2_AMT_SEC_CT | NUMBER | |||
CURRENT_BUCKET_2_COUNT_CT | NUMBER | |||
CURRENT_BUCKET_3_AMT_FUNC_CT | NUMBER | |||
CURRENT_BUCKET_3_AMT_PRIM_CT | NUMBER | |||
CURRENT_BUCKET_3_AMT_SEC_CT | NUMBER | |||
CURRENT_BUCKET_3_COUNT_CT | NUMBER | |||
PAST_DUE_BUCKET_1_AMT_FUNC_CT | NUMBER | |||
PAST_DUE_BUCKET_1_AMT_PRIM_CT | NUMBER | |||
PAST_DUE_BUCKET_1_AMT_SEC_CT | NUMBER | |||
PAST_DUE_BUCKET_1_COUNT_CT | NUMBER | |||
PAST_DUE_BUCKET_2_AMT_FUNC_CT | NUMBER | |||
PAST_DUE_BUCKET_2_AMT_PRIM_CT | NUMBER | |||
PAST_DUE_BUCKET_2_AMT_SEC_CT | NUMBER | |||
PAST_DUE_BUCKET_2_COUNT_CT | NUMBER | |||
PAST_DUE_BUCKET_3_AMT_FUNC_CT | NUMBER | |||
PAST_DUE_BUCKET_3_AMT_PRIM_CT | NUMBER | |||
PAST_DUE_BUCKET_3_AMT_SEC_CT | NUMBER | |||
PAST_DUE_BUCKET_3_COUNT_CT | NUMBER | |||
PAST_DUE_BUCKET_4_AMT_FUNC_CT | NUMBER | |||
PAST_DUE_BUCKET_4_AMT_PRIM_CT | NUMBER | |||
PAST_DUE_BUCKET_4_AMT_SEC_CT | NUMBER | |||
PAST_DUE_BUCKET_4_COUNT_CT | NUMBER | |||
PAST_DUE_BUCKET_5_AMT_FUNC_CT | NUMBER | |||
PAST_DUE_BUCKET_5_AMT_PRIM_CT | NUMBER | |||
PAST_DUE_BUCKET_5_AMT_SEC_CT | NUMBER | |||
PAST_DUE_BUCKET_5_COUNT_CT | NUMBER | |||
PAST_DUE_BUCKET_6_AMT_FUNC_CT | NUMBER | |||
PAST_DUE_BUCKET_6_AMT_PRIM_CT | NUMBER | |||
PAST_DUE_BUCKET_6_AMT_SEC_CT | NUMBER | |||
PAST_DUE_BUCKET_6_COUNT_CT | NUMBER | |||
PAST_DUE_BUCKET_7_AMT_FUNC_CT | NUMBER | |||
PAST_DUE_BUCKET_7_AMT_PRIM_CT | NUMBER | |||
PAST_DUE_BUCKET_7_AMT_SEC_CT | NUMBER | |||
PAST_DUE_BUCKET_7_COUNT_CT | NUMBER | |||
CURRENT_OPEN_AMT_FUNC_CT | NUMBER | |||
CURRENT_OPEN_AMT_PRIM_CT | NUMBER | |||
CURRENT_OPEN_AMT_SEC_CT | NUMBER | |||
CURRENT_OPEN_COUNT_CT | NUMBER | |||
PAST_DUE_OPEN_AMT_FUNC_CT | NUMBER | |||
PAST_DUE_OPEN_AMT_PRIM_CT | NUMBER | |||
PAST_DUE_OPEN_AMT_SEC_CT | NUMBER | |||
PAST_DUE_COUNT_CT | NUMBER | |||
WTD_TERMS_OUT_OPEN_NUM_FUNC_CT | NUMBER | |||
WTD_TERMS_OUT_OPEN_NUM_PRIM_CT | NUMBER | |||
WTD_TERMS_OUT_OPEN_NUM_SEC_CT | NUMBER | |||
WTD_TERMS_OUT_CRT_NUM_FUNC_CT | NUMBER | |||
WTD_TERMS_OUT_CRT_NUM_PRIM_CT | NUMBER | |||
WTD_TERMS_OUT_CRT_NUM_SEC_CT | NUMBER | |||
WTD_DDSO_DUE_NUM_FUNC_CT | NUMBER | |||
WTD_DDSO_DUE_NUM_PRIM_CT | NUMBER | |||
WTD_DDSO_DUE_NUM_SEC_CT | NUMBER | |||
TOTAL_OPEN_AMT_FUNC_CT | NUMBER | |||
TOTAL_OPEN_AMT_PRIM_CT | NUMBER | |||
TOTAL_OPEN_AMT_SEC_CT | NUMBER | |||
TOTAL_OPEN_COUNT_CT | NUMBER | |||
INV_AMT_FUNC_CT | NUMBER | |||
INV_AMT_PRIM_CT | NUMBER | |||
INV_AMT_SEC_CT | NUMBER | |||
DM_AMT_FUNC_CT | NUMBER | |||
DM_AMT_PRIM_CT | NUMBER | |||
DM_AMT_SEC_CT | NUMBER | |||
CB_AMT_FUNC_CT | NUMBER | |||
CB_AMT_PRIM_CT | NUMBER | |||
CB_AMT_SEC_CT | NUMBER | |||
BR_AMT_FUNC_CT | NUMBER | |||
BR_AMT_PRIM_CT | NUMBER | |||
BR_AMT_SEC_CT | NUMBER | |||
DEP_AMT_FUNC_CT | NUMBER | |||
DEP_AMT_PRIM_CT | NUMBER | |||
DEP_AMT_SEC_CT | NUMBER | |||
ON_ACCOUNT_CREDIT_AMT_FUNC_CT | NUMBER | |||
ON_ACCOUNT_CREDIT_AMT_PRIM_CT | NUMBER | |||
ON_ACCOUNT_CREDIT_AMT_SEC_CT | NUMBER | |||
UNAPP_DEP_AMT_FUNC_CT | NUMBER | |||
UNAPP_DEP_AMT_PRIM_CT | NUMBER | |||
UNAPP_DEP_AMT_SEC_CT | NUMBER | |||
APP_AMT_FUNC_CT | NUMBER | |||
APP_AMT_PRIM_CT | NUMBER | |||
APP_AMT_SEC_CT | NUMBER | |||
APP_COUNT_CT | NUMBER | |||
ON_ACCOUNT_CASH_AMT_FUNC_CT | NUMBER | |||
ON_ACCOUNT_CASH_AMT_PRIM_CT | NUMBER | |||
ON_ACCOUNT_CASH_AMT_SEC_CT | NUMBER | |||
PREPAYMENT_AMT_FUNC_CT | NUMBER | |||
PREPAYMENT_AMT_PRIM_CT | NUMBER | |||
PREPAYMENT_AMT_SEC_CT | NUMBER | |||
CLAIM_AMT_FUNC_CT | NUMBER | |||
CLAIM_AMT_PRIM_CT | NUMBER | |||
CLAIM_AMT_SEC_CT | NUMBER | |||
REV_AMT_FUNC_CT | NUMBER | |||
REV_AMT_PRIM_CT | NUMBER | |||
REV_AMT_SEC_CT | NUMBER | |||
REV_COUNT_CT | NUMBER | |||
TOTAL_RECEIPT_AMT_FUNC_CT | NUMBER | |||
TOTAL_RECEIPT_AMT_PRIM_CT | NUMBER | |||
TOTAL_RECEIPT_AMT_SEC_CT | NUMBER | |||
TOTAL_RECEIPT_COUNT_CT | NUMBER | |||
EARNED_DISCOUNT_AMT_FUNC_CT | NUMBER | |||
EARNED_DISCOUNT_AMT_PRIM_CT | NUMBER | |||
EARNED_DISCOUNT_AMT_SEC_CT | NUMBER | |||
UNEARNED_DISCOUNT_AMT_FUNC_CT | NUMBER | |||
UNEARNED_DISCOUNT_AMT_PRIM_CT | NUMBER | |||
UNEARNED_DISCOUNT_AMT_SEC_CT | NUMBER | |||
AVG_DD_NUM_FUNC_CT | NUMBER | |||
AVG_DD_NUM_PRIM_CT | NUMBER | |||
AVG_DD_NUM_SEC_CT | NUMBER | |||
WTD_DAYS_PAID_NUM_FUNC_CT | NUMBER | |||
WTD_DAYS_PAID_NUM_PRIM_CT | NUMBER | |||
WTD_DAYS_PAID_NUM_SEC_CT | NUMBER | |||
WTD_TERMS_PAID_NUM_FUNC_CT | NUMBER | |||
WTD_TERMS_PAID_NUM_PRIM_CT | NUMBER | |||
WTD_TERMS_PAID_NUM_SEC_CT | NUMBER | |||
BILLED_AMT_FUNC_CT | NUMBER | |||
BILLED_AMT_PRIM_CT | NUMBER | |||
BILLED_AMT_SEC_CT | NUMBER | |||
BILLING_ACTIVITY_AMT_FUNC_CT | NUMBER | |||
BILLING_ACTIVITY_AMT_PRIM_CT | NUMBER | |||
BILLING_ACTIVITY_AMT_SEC_CT | NUMBER | |||
BILLING_ACTIVITY_COUNT_CT | NUMBER | |||
CT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT UMARKER
, ENT_YEAR_ID
, ENT_QTR_ID
, ENT_PERIOD_ID
, ENT_WEEK_ID
, REPORT_DATE_JULIAN
, GID
, 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_AMOUNT_PRIM
, CURRENT_BUCKET_1_AMOUNT_SEC
, CURRENT_BUCKET_1_COUNT
, CURRENT_BUCKET_2_AMOUNT_FUNC
, CURRENT_BUCKET_2_AMOUNT_PRIM
, CURRENT_BUCKET_2_AMOUNT_SEC
, CURRENT_BUCKET_2_COUNT
, CURRENT_BUCKET_3_AMOUNT_FUNC
, CURRENT_BUCKET_3_AMOUNT_PRIM
, CURRENT_BUCKET_3_AMOUNT_SEC
, CURRENT_BUCKET_3_COUNT
, PAST_DUE_BUCKET_1_AMOUNT_FUNC
, PAST_DUE_BUCKET_1_AMOUNT_PRIM
, PAST_DUE_BUCKET_1_AMOUNT_SEC
, PAST_DUE_BUCKET_1_COUNT
, PAST_DUE_BUCKET_2_AMOUNT_FUNC
, PAST_DUE_BUCKET_2_AMOUNT_PRIM
, PAST_DUE_BUCKET_2_AMOUNT_SEC
, PAST_DUE_BUCKET_2_COUNT
, PAST_DUE_BUCKET_3_AMOUNT_FUNC
, PAST_DUE_BUCKET_3_AMOUNT_PRIM
, PAST_DUE_BUCKET_3_AMOUNT_SEC
, PAST_DUE_BUCKET_3_COUNT
, PAST_DUE_BUCKET_4_AMOUNT_FUNC
, PAST_DUE_BUCKET_4_AMOUNT_PRIM
, PAST_DUE_BUCKET_4_AMOUNT_SEC
, PAST_DUE_BUCKET_4_COUNT
, PAST_DUE_BUCKET_5_AMOUNT_FUNC
, PAST_DUE_BUCKET_5_AMOUNT_PRIM
, PAST_DUE_BUCKET_5_AMOUNT_SEC
, PAST_DUE_BUCKET_5_COUNT
, PAST_DUE_BUCKET_6_AMOUNT_FUNC
, PAST_DUE_BUCKET_6_AMOUNT_PRIM
, PAST_DUE_BUCKET_6_AMOUNT_SEC
, PAST_DUE_BUCKET_6_COUNT
, PAST_DUE_BUCKET_7_AMOUNT_FUNC
, PAST_DUE_BUCKET_7_AMOUNT_PRIM
, PAST_DUE_BUCKET_7_AMOUNT_SEC
, PAST_DUE_BUCKET_7_COUNT
, CURRENT_OPEN_AMOUNT_FUNC
, CURRENT_OPEN_AMOUNT_PRIM
, CURRENT_OPEN_AMOUNT_SEC
, CURRENT_OPEN_COUNT
, PAST_DUE_OPEN_AMOUNT_FUNC
, PAST_DUE_OPEN_AMOUNT_PRIM
, PAST_DUE_OPEN_AMOUNT_SEC
, PAST_DUE_COUNT
, WTD_TERMS_OUT_OPEN_NUM_FUNC
, WTD_TERMS_OUT_OPEN_NUM_PRIM
, WTD_TERMS_OUT_OPEN_NUM_SEC
, WTD_TERMS_OUT_CURRENT_NUM_FUNC
, WTD_TERMS_OUT_CURRENT_NUM_PRIM
, WTD_TERMS_OUT_CURRENT_NUM_SEC
, WTD_DDSO_DUE_NUM_FUNC
, WTD_DDSO_DUE_NUM_PRIM
, WTD_DDSO_DUE_NUM_SEC
, TOTAL_OPEN_AMOUNT_FUNC
, TOTAL_OPEN_AMOUNT_PRIM
, TOTAL_OPEN_AMOUNT_SEC
, TOTAL_OPEN_COUNT
, INV_AMOUNT_FUNC
, INV_AMOUNT_PRIM
, INV_AMOUNT_SEC
, DM_AMOUNT_FUNC
, DM_AMOUNT_PRIM
, DM_AMOUNT_SEC
, CB_AMOUNT_FUNC
, CB_AMOUNT_PRIM
, CB_AMOUNT_SEC
, BR_AMOUNT_FUNC
, BR_AMOUNT_PRIM
, BR_AMOUNT_SEC
, DEP_AMOUNT_FUNC
, DEP_AMOUNT_PRIM
, DEP_AMOUNT_SEC
, ON_ACCOUNT_CREDIT_AMOUNT_FUNC
, ON_ACCOUNT_CREDIT_AMOUNT_PRIM
, ON_ACCOUNT_CREDIT_AMOUNT_SEC
, UNAPP_DEP_AMOUNT_FUNC
, UNAPP_DEP_AMOUNT_PRIM
, UNAPP_DEP_AMOUNT_SEC
, APP_AMOUNT_FUNC
, APP_AMOUNT_PRIM
, APP_AMOUNT_SEC
, APP_COUNT
, ON_ACCOUNT_CASH_AMOUNT_FUNC
, ON_ACCOUNT_CASH_AMOUNT_PRIM
, ON_ACCOUNT_CASH_AMOUNT_SEC
, PREPAYMENT_AMOUNT_FUNC
, PREPAYMENT_AMOUNT_PRIM
, PREPAYMENT_AMOUNT_SEC
, CLAIM_AMOUNT_FUNC
, CLAIM_AMOUNT_PRIM
, CLAIM_AMOUNT_SEC
, REV_AMOUNT_FUNC
, REV_AMOUNT_PRIM
, REV_AMOUNT_SEC
, REV_COUNT
, TOTAL_RECEIPT_AMOUNT_FUNC
, TOTAL_RECEIPT_AMOUNT_PRIM
, TOTAL_RECEIPT_AMOUNT_SEC
, TOTAL_RECEIPT_COUNT
, EARNED_DISCOUNT_AMOUNT_FUNC
, EARNED_DISCOUNT_AMOUNT_PRIM
, EARNED_DISCOUNT_AMOUNT_SEC
, UNEARNED_DISCOUNT_AMOUNT_FUNC
, UNEARNED_DISCOUNT_AMOUNT_PRIM
, UNEARNED_DISCOUNT_AMOUNT_SEC
, AVG_DD_NUM_FUNC
, AVG_DD_NUM_PRIM
, AVG_DD_NUM_SEC
, WTD_DAYS_PAID_NUM_FUNC
, WTD_DAYS_PAID_NUM_PRIM
, WTD_DAYS_PAID_NUM_SEC
, WTD_TERMS_PAID_NUM_FUNC
, WTD_TERMS_PAID_NUM_PRIM
, WTD_TERMS_PAID_NUM_SEC
, BILLED_AMOUNT_FUNC
, BILLED_AMOUNT_PRIM
, BILLED_AMOUNT_SEC
, BILLING_ACTIVITY_AMOUNT_FUNC
, BILLING_ACTIVITY_AMOUNT_PRIM
, BILLING_ACTIVITY_AMOUNT_SEC
, BILLING_ACTIVITY_COUNT
, CURRENT_BUCKET_1_AMT_FUNC_CT
, CURRENT_BUCKET_1_AMT_PRIM_CT
, CURRENT_BUCKET_1_AMT_SEC_CT
, CURRENT_BUCKET_1_COUNT_CT
, CURRENT_BUCKET_2_AMT_FUNC_CT
, CURRENT_BUCKET_2_AMT_PRIM_CT
, CURRENT_BUCKET_2_AMT_SEC_CT
, CURRENT_BUCKET_2_COUNT_CT
, CURRENT_BUCKET_3_AMT_FUNC_CT
, CURRENT_BUCKET_3_AMT_PRIM_CT
, CURRENT_BUCKET_3_AMT_SEC_CT
, CURRENT_BUCKET_3_COUNT_CT
, PAST_DUE_BUCKET_1_AMT_FUNC_CT
, PAST_DUE_BUCKET_1_AMT_PRIM_CT
, PAST_DUE_BUCKET_1_AMT_SEC_CT
, PAST_DUE_BUCKET_1_COUNT_CT
, PAST_DUE_BUCKET_2_AMT_FUNC_CT
, PAST_DUE_BUCKET_2_AMT_PRIM_CT
, PAST_DUE_BUCKET_2_AMT_SEC_CT
, PAST_DUE_BUCKET_2_COUNT_CT
, PAST_DUE_BUCKET_3_AMT_FUNC_CT
, PAST_DUE_BUCKET_3_AMT_PRIM_CT
, PAST_DUE_BUCKET_3_AMT_SEC_CT
, PAST_DUE_BUCKET_3_COUNT_CT
, PAST_DUE_BUCKET_4_AMT_FUNC_CT
, PAST_DUE_BUCKET_4_AMT_PRIM_CT
, PAST_DUE_BUCKET_4_AMT_SEC_CT
, PAST_DUE_BUCKET_4_COUNT_CT
, PAST_DUE_BUCKET_5_AMT_FUNC_CT
, PAST_DUE_BUCKET_5_AMT_PRIM_CT
, PAST_DUE_BUCKET_5_AMT_SEC_CT
, PAST_DUE_BUCKET_5_COUNT_CT
, PAST_DUE_BUCKET_6_AMT_FUNC_CT
, PAST_DUE_BUCKET_6_AMT_PRIM_CT
, PAST_DUE_BUCKET_6_AMT_SEC_CT
, PAST_DUE_BUCKET_6_COUNT_CT
, PAST_DUE_BUCKET_7_AMT_FUNC_CT
, PAST_DUE_BUCKET_7_AMT_PRIM_CT
, PAST_DUE_BUCKET_7_AMT_SEC_CT
, PAST_DUE_BUCKET_7_COUNT_CT
, CURRENT_OPEN_AMT_FUNC_CT
, CURRENT_OPEN_AMT_PRIM_CT
, CURRENT_OPEN_AMT_SEC_CT
, CURRENT_OPEN_COUNT_CT
, PAST_DUE_OPEN_AMT_FUNC_CT
, PAST_DUE_OPEN_AMT_PRIM_CT
, PAST_DUE_OPEN_AMT_SEC_CT
, PAST_DUE_COUNT_CT
, WTD_TERMS_OUT_OPEN_NUM_FUNC_CT
, WTD_TERMS_OUT_OPEN_NUM_PRIM_CT
, WTD_TERMS_OUT_OPEN_NUM_SEC_CT
, WTD_TERMS_OUT_CRT_NUM_FUNC_CT
, WTD_TERMS_OUT_CRT_NUM_PRIM_CT
, WTD_TERMS_OUT_CRT_NUM_SEC_CT
, WTD_DDSO_DUE_NUM_FUNC_CT
, WTD_DDSO_DUE_NUM_PRIM_CT
, WTD_DDSO_DUE_NUM_SEC_CT
, TOTAL_OPEN_AMT_FUNC_CT
, TOTAL_OPEN_AMT_PRIM_CT
, TOTAL_OPEN_AMT_SEC_CT
, TOTAL_OPEN_COUNT_CT
, INV_AMT_FUNC_CT
, INV_AMT_PRIM_CT
, INV_AMT_SEC_CT
, DM_AMT_FUNC_CT
, DM_AMT_PRIM_CT
, DM_AMT_SEC_CT
, CB_AMT_FUNC_CT
, CB_AMT_PRIM_CT
, CB_AMT_SEC_CT
, BR_AMT_FUNC_CT
, BR_AMT_PRIM_CT
, BR_AMT_SEC_CT
, DEP_AMT_FUNC_CT
, DEP_AMT_PRIM_CT
, DEP_AMT_SEC_CT
, ON_ACCOUNT_CREDIT_AMT_FUNC_CT
, ON_ACCOUNT_CREDIT_AMT_PRIM_CT
, ON_ACCOUNT_CREDIT_AMT_SEC_CT
, UNAPP_DEP_AMT_FUNC_CT
, UNAPP_DEP_AMT_PRIM_CT
, UNAPP_DEP_AMT_SEC_CT
, APP_AMT_FUNC_CT
, APP_AMT_PRIM_CT
, APP_AMT_SEC_CT
, APP_COUNT_CT
, ON_ACCOUNT_CASH_AMT_FUNC_CT
, ON_ACCOUNT_CASH_AMT_PRIM_CT
, ON_ACCOUNT_CASH_AMT_SEC_CT
, PREPAYMENT_AMT_FUNC_CT
, PREPAYMENT_AMT_PRIM_CT
, PREPAYMENT_AMT_SEC_CT
, CLAIM_AMT_FUNC_CT
, CLAIM_AMT_PRIM_CT
, CLAIM_AMT_SEC_CT
, REV_AMT_FUNC_CT
, REV_AMT_PRIM_CT
, REV_AMT_SEC_CT
, REV_COUNT_CT
, TOTAL_RECEIPT_AMT_FUNC_CT
, TOTAL_RECEIPT_AMT_PRIM_CT
, TOTAL_RECEIPT_AMT_SEC_CT
, TOTAL_RECEIPT_COUNT_CT
, EARNED_DISCOUNT_AMT_FUNC_CT
, EARNED_DISCOUNT_AMT_PRIM_CT
, EARNED_DISCOUNT_AMT_SEC_CT
, UNEARNED_DISCOUNT_AMT_FUNC_CT
, UNEARNED_DISCOUNT_AMT_PRIM_CT
, UNEARNED_DISCOUNT_AMT_SEC_CT
, AVG_DD_NUM_FUNC_CT
, AVG_DD_NUM_PRIM_CT
, AVG_DD_NUM_SEC_CT
, WTD_DAYS_PAID_NUM_FUNC_CT
, WTD_DAYS_PAID_NUM_PRIM_CT
, WTD_DAYS_PAID_NUM_SEC_CT
, WTD_TERMS_PAID_NUM_FUNC_CT
, WTD_TERMS_PAID_NUM_PRIM_CT
, WTD_TERMS_PAID_NUM_SEC_CT
, BILLED_AMT_FUNC_CT
, BILLED_AMT_PRIM_CT
, BILLED_AMT_SEC_CT
, BILLING_ACTIVITY_AMT_FUNC_CT
, BILLING_ACTIVITY_AMT_PRIM_CT
, BILLING_ACTIVITY_AMT_SEC_CT
, BILLING_ACTIVITY_COUNT_CT
, CT
FROM APPS.FII_AR_NET_REC_INTR_MV;
|
|
|