eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OPI.OPI_DBI_PTP_COST

Object Details

Object Name:	OPI_DBI_PTP_COST
Object Type:	TABLE
Owner:	OPI
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_PTP_COST_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SOURCE FROZEN_FLAG

Columns

Name	Datatype	Mandatory	Comments
FROZEN_FLAG	NUMBER		Frozen Flag.
ORGANIZATION_ID	NUMBER	Yes	Organization ID.
INVENTORY_ITEM_ID	NUMBER	Yes	Inventory Item ID.
UNIT_COST	NUMBER		Unit Cost.
FROM_DATE	DATE		From Date.
TO_DATE	DATE		To Date.
SOURCE	NUMBER	Yes	Source (1:OPI, 2:OPM).
CREATION_DATE	DATE	Yes	Who Column.
CREATED_BY	NUMBER	Yes	Who Column.
LAST_UPDATE_DATE	DATE	Yes	Who Column.
LAST_UPDATED_BY	NUMBER	Yes	Who Column.
LAST_UPDATE_LOGIN	NUMBER		Who Column.

Query Text

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


SELECT FROZEN_FLAG
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      UNIT_COST
,      FROM_DATE
,      TO_DATE
,      SOURCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OPI.OPI_DBI_PTP_COST;

Dependencies

[top of page]

OPI.OPI_DBI_PTP_COST does not reference any database object

OPI.OPI_DBI_PTP_COST is referenced by following:

APPS: OPI_DBI_PTP_COST; OPI_PTP_CBN_MV; OPI_PTP_SUM_STG_MV