[Home] [Help] [Dependency Information]
Object Name: | FII_AR_NET_REC_AGRT_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_SNAP$_FII_AR_NET_REC_AGR | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY |
SYS_OP_MAP_NONNULL("TIME_ID")
SYS_OP_MAP_NONNULL("PERIOD_TYPE_ID") SYS_OP_MAP_NONNULL("PARENT_PARTY_ID") SYS_OP_MAP_NONNULL("PARTY_ID") SYS_OP_MAP_NONNULL("COLLECTOR_ID") SYS_OP_MAP_NONNULL("ORG_ID") SYS_OP_MAP_NONNULL("HEADER_FILTER_DATE") SYS_OP_MAP_NONNULL("GID") SYS_OP_MAP_NONNULL("UMARKER") |
FII_AR_NET_REC_AGRT_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
TIME_ID
PERIOD_TYPE_ID ORG_ID GID PARTY_ID PARENT_PARTY_ID COLLECTOR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
PARENT_PARTY_ID | NUMBER | (15) | ||
PARTY_ID | NUMBER | (15) | ||
CUST_ACCOUNT_ID | NUMBER | |||
COLLECTOR_ID | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
HEADER_FILTER_DATE | DATE | |||
GID | NUMBER | |||
UMARKER | VARCHAR2 | (10) | ||
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_DSCT_AMT_FUNC_CT | NUMBER | |||
EARNED_DSCT_AMT_PRIM_CT | NUMBER | |||
EARNED_DSCT_AMT_SEC_CT | NUMBER | |||
UNEARNED_DSCT_AMT_FUNC_CT | NUMBER | |||
UNEARNED_DSCT_AMT_PRIM_CT | NUMBER | |||
UNEARNED_DSCT_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 TIME_ID
, PERIOD_TYPE_ID
, PARENT_PARTY_ID
, PARTY_ID
, CUST_ACCOUNT_ID
, COLLECTOR_ID
, ORG_ID
, HEADER_FILTER_DATE
, GID
, UMARKER
, 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_DSCT_AMT_FUNC_CT
, EARNED_DSCT_AMT_PRIM_CT
, EARNED_DSCT_AMT_SEC_CT
, UNEARNED_DSCT_AMT_FUNC_CT
, UNEARNED_DSCT_AMT_PRIM_CT
, UNEARNED_DSCT_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_AGRT_MV;
APPS.FII_AR_NET_REC_AGRT_MV does not reference any database object
APPS.FII_AR_NET_REC_AGRT_MV is referenced by following:
|
|
|