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

MATERIALIZED VIEW: APPS.POA_ITEMS_MV

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

AP_SUPPLIERS
POA_ITEMS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TRID ROWID (10)
TRID
VRID ROWID (10)
VRID
PO_ITEM_ID NUMBER
Yes Purchased Item Identifier
VENDOR_PRODUCT_NUM VARCHAR2 (125)
Vendor Item Number
VENDOR_NAME VARCHAR2 (240)
Vendor Name
DESCRIPTION VARCHAR2 (240)
Item Description
CATEGORY_ID NUMBER

Purchased Category Identifier
Query Text

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


SELECT TRID
,      VRID
,      PO_ITEM_ID
,      VENDOR_PRODUCT_NUM
,      VENDOR_NAME
,      DESCRIPTION
,      CATEGORY_ID
FROM APPS.POA_ITEMS_MV;

Dependencies

[top of page]

APPS.POA_ITEMS_MV references the following:

SchemaAP
TableAP_SUPPLIERS
SchemaAPPS
TablePOA_ITEMS_MV
SchemaPOA
TablePOA_ITEMS

APPS.POA_ITEMS_MV is not referenced by any database object