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_CURR_UNREC_VAR_F

Object Details

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

Fact Table for Current Unrecognized Variance ETL.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OPI_DBI_CURR_UNREC_VAR_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID INVENTORY_ITEM_ID JOB_ID JOB_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER			Organization in which the job is created.
INVENTORY_ITEM_ID	NUMBER			Assembly Inventory Item Id.
ITEM_ORG_ID	VARCHAR2	(100)	Yes	Item-Org Id.
INV_CATEGORY_ID	NUMBER			Inventory Category of the Assembly.
STANDARD_VALUE_B	NUMBER			Standard Cost of of open jobs in functional currency.
STANDARD_VALUE_G	NUMBER			Standard Cost of of open jobs in global currency.
ACTUAL_VALUE_B	NUMBER			Total Cost charged to open jobs in functional currency.
ACTUAL_VALUE_G	NUMBER			Total Cost charged to open jobs in global currency.
ACTUAL_PRD_QTY	NUMBER			Actual Production Quantity of the Assembly. i.e. WIP Completions - WIP Returns.
UOM_CODE	VARCHAR2	(3)		Primary Unit of Measure of the assembly.
SOURCE	NUMBER		Yes	Source: 1 if OPI or 2 if OPM.
CREATION_DATE	DATE		Yes	Creation Date.
LAST_UPDATE_DATE	DATE		Yes	Last Update Date.
CREATED_BY	NUMBER		Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column.
STANDARD_VALUE_SG	NUMBER			Standard Production Value in secondary global currency
ACTUAL_VALUE_SG	NUMBER			Actual Production Value in Secondary global currency
JOB_ID	NUMBER			Job Id
JOB_TYPE	NUMBER			1-Discrete Jobs 2-Repetetive Schedules 3-Flow Schedules 4-OPM Batches
PROGRAM_ID	NUMBER			Who Column.
PROGRAM_LOGIN_ID	NUMBER			Who Column.
PROGRAM_APPLICATION_ID	NUMBER			Who Column.
REQUEST_ID	NUMBER			Who Column.

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_ORG_ID
,      INV_CATEGORY_ID
,      STANDARD_VALUE_B
,      STANDARD_VALUE_G
,      ACTUAL_VALUE_B
,      ACTUAL_VALUE_G
,      ACTUAL_PRD_QTY
,      UOM_CODE
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      STANDARD_VALUE_SG
,      ACTUAL_VALUE_SG
,      JOB_ID
,      JOB_TYPE
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OPI.OPI_DBI_CURR_UNREC_VAR_F;

Dependencies

[top of page]

OPI.OPI_DBI_CURR_UNREC_VAR_F does not reference any database object

OPI.OPI_DBI_CURR_UNREC_VAR_F is referenced by following:

APPS: OPI_DBI_CURR_UNREC_VAR_F