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

TABLE: APPS.OPI_PTP_CBN_MV

Object Details
Object Name: OPI_PTP_CBN_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.OPI_PTP_CBN_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
F_ROWID ROWID (10)
Row Identifier column.
COST_ROWID ROWID (10)
Row Identifier column.
CONV_ROWID ROWID (10)
Row Identifier column.
ORGANIZATION_ID NUMBER

Inventory Organization Identifier.
INVENTORY_ITEM_ID NUMBER

Inventory Item Identifier.
TRANSACTION_DATE DATE

Transaction Date.
ACTUAL_QUANTITY NUMBER

Actual Quantity in Primary UOM.
ACTUAL_QUANTITY_CNT NUMBER

Count column.
PLANNED_QUANTITY NUMBER

Planned Quantity in Primary UOM.
PLANNED_ITEM VARCHAR2 (1)
Planned Item Flag.
UOM_CODE VARCHAR2 (3)
Primary UOM Code.
UNIT_COST NUMBER

Inventory Item Unit Cost.
CONVERSION_RATE NUMBER

Currency Conversion Rate.
MARKER NUMBER

Materialized view marker.
SEC_CONVERSION_RATE NUMBER

Secondary Global Currency Conversion Rate.
CNT NUMBER

Row count.
Query Text

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


SELECT F_ROWID
,      COST_ROWID
,      CONV_ROWID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      TRANSACTION_DATE
,      ACTUAL_QUANTITY
,      ACTUAL_QUANTITY_CNT
,      PLANNED_QUANTITY
,      PLANNED_ITEM
,      UOM_CODE
,      UNIT_COST
,      CONVERSION_RATE
,      MARKER
,      SEC_CONVERSION_RATE
,      CNT
FROM APPS.OPI_PTP_CBN_MV;

Dependencies

[top of page]

APPS.OPI_PTP_CBN_MV does not reference any database object

APPS.OPI_PTP_CBN_MV is referenced by following:

SchemaAPPS
Materialized ViewOPI_PTP_CBN_MV
Materialized ViewOPI_PTP_ITEM_F_MV