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

MATERIALIZED VIEW: APPS.FII_AP_HCAT_IB_MV

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

FII_AP_HCAT_I_MV
     FII_AP_HCAT_B_MV
          FII_AP_INV_HOLDS_B
     FII_TIME_DAY

[View Source Query]

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
HOLD_RELEASE_FLAG CHAR (1)
Flag that indicates invoice is on hold (H) or released (R)
GID NUMBER

Grouping Identifier
VARIANCE_HOLD_COUNT NUMBER

Number of holds of Category INVOICE
VARIANCE_HOLD_COUNTC NUMBER

Internal aggregation for fast refreshable materialized view
PO_MATCHING_HOLD_COUNT NUMBER

Number of holds of Category PO_MATCHING
PO_MATCHING_HOLD_COUNTC NUMBER

Internal aggregation for fast refreshable materialized view
INVOICE_HOLD_COUNT NUMBER

Number of holds of Category INVOICE
INVOICE_HOLD_COUNTC NUMBER

Internal aggregation for fast refreshable materialized view
USER_DEFINED_HOLD_COUNT NUMBER

Number of holds of Category USER_DEFINED
USER_DEFINED_HOLD_COUNTC NUMBER

Internal aggregation for fast refreshable materialized view
OTHER_HOLD_COUNT NUMBER

Total number of holds of categories other than VARIANCE, PO MATCHING, INVOICE, USER DEFINED
OTHER_HOLD_COUNTC NUMBER

Internal aggregation for fast refreshable materialized view
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
,      TIME_ID
,      PERIOD_TYPE_ID
,      HOLD_RELEASE_FLAG
,      GID
,      VARIANCE_HOLD_COUNT
,      VARIANCE_HOLD_COUNTC
,      PO_MATCHING_HOLD_COUNT
,      PO_MATCHING_HOLD_COUNTC
,      INVOICE_HOLD_COUNT
,      INVOICE_HOLD_COUNTC
,      USER_DEFINED_HOLD_COUNT
,      USER_DEFINED_HOLD_COUNTC
,      OTHER_HOLD_COUNT
,      OTHER_HOLD_COUNTC
,      CNT
FROM APPS.FII_AP_HCAT_IB_MV;

Dependencies

[top of page]

APPS.FII_AP_HCAT_IB_MV references the following:

SchemaAPPS
TableFII_AP_HCAT_IB_MV
TableFII_AP_HCAT_I_MV
Materialized ViewFII_AP_HCAT_I_MV

APPS.FII_AP_HCAT_IB_MV is not referenced by any database object