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

MATERIALIZED VIEW: APPS.FII_AP_HHIST_IB_MV

Object Details
Object Name: FII_AP_HHIST_IB_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: FII_AP_HHIST_IB_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:

BIS_SYSTEM_DATE
FII_AP_HHIST_I_MV
     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_DATE DATE

Date on which the hold was placed
RELEASE_TIME_ID NUMBER

Time identifier when the invoice was released. Null if it has not been released
RELEASE_DATE DATE

Date on which the hold was released.
DAYS_ON_HOLD NUMBER

Number of days invoice was placed on hold
SUM(1) NUMBER

COUNT(1) NUMBER

COUNT(*) NUMBER

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_DATE
,      RELEASE_TIME_ID
,      RELEASE_DATE
,      DAYS_ON_HOLD
,      SUM(1)
,      COUNT(1)
,      COUNT(*)
FROM APPS.FII_AP_HHIST_IB_MV;

Dependencies

[top of page]

APPS.FII_AP_HHIST_IB_MV references the following:

SchemaAPPS
TableFII_AP_HHIST_IB_MV
TableFII_AP_HHIST_I_MV
Materialized ViewFII_AP_HHIST_I_MV
SchemaBIS
TableBIS_SYSTEM_DATE
APPS.FII_AP_HHIST_IB_MV is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_HATY_XB_MV
Materialized ViewFII_AP_HLIA_IB_MV
Materialized ViewFII_AP_HLIA_I_MV
Materialized ViewFII_AP_INV_B_MV