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


MATERIALIZED VIEW: APPS.FII_AP_HHIST_I_MV

Object Details
Object Name: FII_AP_HHIST_I_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_AP_HHIST_I_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

FII_AP_HHIST_B_MV
     FII_AP_HOLD_HIST_B

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating unit identifier
SUPPLIER_ID NUMBER (15)
Supplier Identifier
INVOICE_ID NUMBER (15)
Invoice identifier
PERIOD_TYPE_ID NUMBER

Period type Identifier
HOLD_TIME_ID NUMBER

Time identifier when the invoice was placed on hold.
HOLD_TIME_IDC NUMBER

Internal aggregation for fast refreshable materialized view
HOLD_DATE DATE

Date on which the hold was placed
HOLD_DATEC NUMBER

Internal aggregation for fast refreshable materialized view
RELEASE_TIME_ID NUMBER

Time identifier when the invoice was released
RELEASE_TIME_IDC NUMBER

Internal aggregation for fast refreshable materialized view
RELEASE_DATE DATE

Date on which the hold was released
RELEASE_DATEC NUMBER

Internal aggregation for fast refreshable materialized view
SEQ_ID NUMBER (15)
Sequence id for number of holds placed
CNT NUMBER

Used for Fast refresh MV to be enabled
Query Text

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


SELECT ORG_ID
,      SUPPLIER_ID
,      INVOICE_ID
,      PERIOD_TYPE_ID
,      HOLD_TIME_ID
,      HOLD_TIME_IDC
,      HOLD_DATE
,      HOLD_DATEC
,      RELEASE_TIME_ID
,      RELEASE_TIME_IDC
,      RELEASE_DATE
,      RELEASE_DATEC
,      SEQ_ID
,      CNT
FROM APPS.FII_AP_HHIST_I_MV;

Dependencies

[top of page]

APPS.FII_AP_HHIST_I_MV references the following:

SchemaAPPS
TableFII_AP_HHIST_B_MV
Materialized ViewFII_AP_HHIST_B_MV
TableFII_AP_HHIST_I_MV
APPS.FII_AP_HHIST_I_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_HHIST_IB_MV