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

TABLE: APPS.FII_AP_HLIA_I_MV

Object Details
Object Name: FII_AP_HLIA_I_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.FII_AP_HLIA_I_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AP_HLIA_I_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGID
ColumnPERIOD_TYPE_ID
ColumnTIME_ID
ColumnORG_ID
FII_AP_HLIA_I_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGID
ColumnPERIOD_TYPE_ID
ColumnTIME_ID
ColumnSUPPLIER_ID
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating Unit Identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
TIME_ID NUMBER

Time identifier
PERIOD_TYPE_ID NUMBER

Period Type Identifier
GID NUMBER

Grouping Identifier
INV_ON_HOLD_AMT_B NUMBER

Total invoice amounts on hold in base currency
INV_ON_HOLD_AMT_PRIM_G NUMBER

Total invoice amounts on hold in primary currency
INV_ON_HOLD_AMT_SEC_G NUMBER

Total invoice amounts on hold in secondary currency
INV_ON_HOLD_COUNT NUMBER

Number of Invoices on hold
ON_HOLD_DUE_COUNT NUMBER

Number of Invoices on hold and are due
DAYS_ON_HOLD NUMBER

Number of days Invoice is on hold
ON_HOLD_PAYMENT_AMOUNT_B NUMBER

Total payment amount for invoices on hold in base currency
ON_HOLD_PAYMENT_AMOUNT_PRIM_G NUMBER

Total payment amount for invoices on hold in primary currency
ON_HOLD_PAYMENT_AMOUNT_SEC_G NUMBER

Total payment amount for invoices on hold in secondary currency
ON_HOLD_PAST_DUE_AMT_B NUMBER

Total past due amount for invoices on hold in base currency
ON_HOLD_PAST_DUE_AMT_PRIM_G NUMBER

Total past due amount for invoices on hold in primary currency
ON_HOLD_PAST_DUE_AMT_SEC_G NUMBER

Total past due amount for invoices on hold in secondary currency
ON_HOLD_PAST_DUE_COUNT NUMBER

Number of invoices on hold and are past due
ON_HOLD_DIS_REMAINING_B NUMBER

Total discount remaining for invoices on hold in base currency
ON_HOLD_DIS_REMAINING_PRIM_G NUMBER

Total discount remaining for invoices on hold in primary currency
ON_HOLD_DIS_REMAINING_SEC_G NUMBER

Total discount remaining for invoices on hold in secondary currency
ON_HOLD_DIS_TAKEN_B NUMBER

Total discount taken for invoices on hold in base currency
ON_HOLD_DIS_TAKEN_PRIM_G NUMBER

Total discount taken for invoices on hold in primary currency
ON_HOLD_DIS_TAKEN_SEC_G NUMBER

Total discount taken for invoices on hold in secondary currency
ON_HOLD_DIS_LOST_B NUMBER

Total discount lost for invoices on hold in base currency
ON_HOLD_DIS_LOST_PRIM_G NUMBER

Total discount lost for invoices on hold in primary currency
ON_HOLD_DIS_LOST_SEC_G NUMBER

Total discount lost for invoices on hold in secondary currency
NO_OF_HOLDS NUMBER

Number of Holds placed on the Invoices
Query Text

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


SELECT ORG_ID
,      SUPPLIER_ID
,      TIME_ID
,      PERIOD_TYPE_ID
,      GID
,      INV_ON_HOLD_AMT_B
,      INV_ON_HOLD_AMT_PRIM_G
,      INV_ON_HOLD_AMT_SEC_G
,      INV_ON_HOLD_COUNT
,      ON_HOLD_DUE_COUNT
,      DAYS_ON_HOLD
,      ON_HOLD_PAYMENT_AMOUNT_B
,      ON_HOLD_PAYMENT_AMOUNT_PRIM_G
,      ON_HOLD_PAYMENT_AMOUNT_SEC_G
,      ON_HOLD_PAST_DUE_AMT_B
,      ON_HOLD_PAST_DUE_AMT_PRIM_G
,      ON_HOLD_PAST_DUE_AMT_SEC_G
,      ON_HOLD_PAST_DUE_COUNT
,      ON_HOLD_DIS_REMAINING_B
,      ON_HOLD_DIS_REMAINING_PRIM_G
,      ON_HOLD_DIS_REMAINING_SEC_G
,      ON_HOLD_DIS_TAKEN_B
,      ON_HOLD_DIS_TAKEN_PRIM_G
,      ON_HOLD_DIS_TAKEN_SEC_G
,      ON_HOLD_DIS_LOST_B
,      ON_HOLD_DIS_LOST_PRIM_G
,      ON_HOLD_DIS_LOST_SEC_G
,      NO_OF_HOLDS
FROM APPS.FII_AP_HLIA_I_MV;

Dependencies

[top of page]

APPS.FII_AP_HLIA_I_MV does not reference any database object

APPS.FII_AP_HLIA_I_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_HLIA_I_MV
Materialized ViewFII_AP_LIA_KPI_MV