DBA Data[Home] [Help] [Dependency Information]

TABLE: FII.FII_AR_TPDUE_BASE_F

Object Details
Object Name: FII_AR_TPDUE_BASE_F
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AR_TPDUE_BASE_F
Subobject Name:
Status: VALID


This is the fact table that stores base data for Top Past Due Customers report.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AR_TPDUE_BASE_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_PARENT_PARTY_ID
ColumnORG_ID
ColumnCUST_CHILD_PARTY_ID
ColumnCUST_NEXT_LEVEL_PARTY_ID
Columns
Name Datatype Length Mandatory Comments
PARENT_PARTY_ID NUMBER (15)
Parent Party Identifier
PARTY_ID NUMBER (15)
Party Identifier
COLLECTOR_ID NUMBER (15)
Collector Identifier
ORG_ID NUMBER (15)
Organization Identifier
IS_LEAF_FLAG VARCHAR2 (1)
Is leaf flag
IS_SELF_FLAG VARCHAR2 (1)
Is self flag
VIEW_BY VARCHAR2 (360)
View by
VIEWBY_CODE VARCHAR2 (30)
View by code
CUST_NEXT_LEVEL_PARTY_ID NUMBER (15)
Next Level Party Id
CUST_PARENT_PARTY_ID NUMBER (15)
Parent Party Id
CUST_CHILD_PARTY_ID NUMBER (15)
Child Party Id
PAST_DUE_OPEN_AMOUNT_FUNC NUMBER

Past Due Open amount in the functional currency
PAST_DUE_OPEN_AMOUNT_PRIM NUMBER

Past Due Open amount in the primary global currency
PAST_DUE_OPEN_AMOUNT_SEC NUMBER

Past Due Open amount in the secondary global currency
WTD_TERMS_OUT_OPEN_NUM_FUNC NUMBER

Weighted terms outstanding amount in the functional currency
WTD_TERMS_OUT_OPEN_NUM_PRIM NUMBER

Weighted terms outstanding amount in the primary global currency
WTD_TERMS_OUT_OPEN_NUM_SEC NUMBER

Weighted terms outstanding amount in the secondary global currency
WTD_DDSO_DUE_NUM_FUNC NUMBER

Weighted Day Sales outstanding amount in the functional currency
WTD_DDSO_DUE_NUM_PRIM NUMBER

Weighted Day Sales outstanding amount in the primary global currency
WTD_DDSO_DUE_NUM_SEC NUMBER

Weighted Day Sales outstanding amount in the secondary global currency
CURRENT_OPEN_AMOUNT_FUNC NUMBER

Current Open amount in the functional currency
CURRENT_OPEN_AMOUNT_PRIM NUMBER

Current Open amount in the primary global currency
CURRENT_OPEN_AMOUNT_SEC NUMBER

Current Open amount in the secondary global currency
PAST_DUE_DISPUTE_AMOUNT_FUNC NUMBER

Past Due Dispute amount in the functional currency
PAST_DUE_DISPUTE_AMOUNT_PRIM NUMBER

Past Due Dispute amount in the primary global currency
PAST_DUE_DISPUTE_AMOUNT_SEC NUMBER

Past Due Dispute amount in the secondary global currency
LAST_UPDATE_DATE DATE
Yes Standard who columns
LAST_UPDATED_BY NUMBER (15) Yes Standard who columns
CREATION_DATE DATE
Yes Standard who columns
CREATED_BY NUMBER (15) Yes Standard who columns
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who columns
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARENT_PARTY_ID
,      PARTY_ID
,      COLLECTOR_ID
,      ORG_ID
,      IS_LEAF_FLAG
,      IS_SELF_FLAG
,      VIEW_BY
,      VIEWBY_CODE
,      CUST_NEXT_LEVEL_PARTY_ID
,      CUST_PARENT_PARTY_ID
,      CUST_CHILD_PARTY_ID
,      PAST_DUE_OPEN_AMOUNT_FUNC
,      PAST_DUE_OPEN_AMOUNT_PRIM
,      PAST_DUE_OPEN_AMOUNT_SEC
,      WTD_TERMS_OUT_OPEN_NUM_FUNC
,      WTD_TERMS_OUT_OPEN_NUM_PRIM
,      WTD_TERMS_OUT_OPEN_NUM_SEC
,      WTD_DDSO_DUE_NUM_FUNC
,      WTD_DDSO_DUE_NUM_PRIM
,      WTD_DDSO_DUE_NUM_SEC
,      CURRENT_OPEN_AMOUNT_FUNC
,      CURRENT_OPEN_AMOUNT_PRIM
,      CURRENT_OPEN_AMOUNT_SEC
,      PAST_DUE_DISPUTE_AMOUNT_FUNC
,      PAST_DUE_DISPUTE_AMOUNT_PRIM
,      PAST_DUE_DISPUTE_AMOUNT_SEC
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM FII.FII_AR_TPDUE_BASE_F;

Dependencies

[top of page]

FII.FII_AR_TPDUE_BASE_F does not reference any database object

FII.FII_AR_TPDUE_BASE_F is referenced by following:

SchemaAPPS
SynonymFII_AR_TPDUE_BASE_F