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]

VIEW: APPS.OPI_EDW_JOB_DETAIL_V

Object Details

Object Name:	OPI_EDW_JOB_DETAIL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OPI.OPI_EDW_JOB_DETAIL_V
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ALL_INV_ID	NUMBER			EDW-Internal Surrogate key to the All Level
PCMP_ID	NUMBER			Primary Key of Parent Group, unique across instances and system types
PORG_ID	NUMBER			EDW-internal ID for Inventory Organization Group
OPERATING_UNIT_ID	NUMBER			EDW-internal Surrogate Key for Operating Unit
PLANT_ID	NUMBER			EDW-internal Surrogate Key for Inventory Organization
ALL_TIME_ID	NUMBER
CAL_YR_ID	NUMBER
CAL_QTR_ID	NUMBER
CAL_PERIOD_ID	NUMBER
ALL_PRDL_ID	NUMBER
PRDL_ID	NUMBER
ALL_ITEMS_ID	NUMBER
ITEM_CAT_ID	VARCHAR2	(240)
ITEM_ID	NUMBER		Yes
ITEM_NUMBER_ID	NUMBER
ITEM_ORG_ID	NUMBER
UOM_ID	NUMBER		Yes
ACT_MTL_INP_VAL_G	NUMBER
PLN_MTL_INP_VAL_G	NUMBER
ACT_OUT_VAL_G	NUMBER
PLN_OUT_VAL_G	NUMBER
ACT_SCR_VAL_G	NUMBER
PLN_SCR_VAL_G	NUMBER
ACT_OUT_QTY	NUMBER
PLN_OUT_QTY	NUMBER
ACT_JOB_TIME	NUMBER
STD_QTY	NUMBER
STND_HRS_EARNED	NUMBER
STD_TIME	NUMBER
LATE_JOB	NUMBER
JOB	NUMBER

Query Text

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


SELECT ALL_INV_ID
,      PCMP_ID
,      PORG_ID
,      OPERATING_UNIT_ID
,      PLANT_ID
,      ALL_TIME_ID
,      CAL_YR_ID
,      CAL_QTR_ID
,      CAL_PERIOD_ID
,      ALL_PRDL_ID
,      PRDL_ID
,      ALL_ITEMS_ID
,      ITEM_CAT_ID
,      ITEM_ID
,      ITEM_NUMBER_ID
,      ITEM_ORG_ID
,      UOM_ID
,      ACT_MTL_INP_VAL_G
,      PLN_MTL_INP_VAL_G
,      ACT_OUT_VAL_G
,      PLN_OUT_VAL_G
,      ACT_SCR_VAL_G
,      PLN_SCR_VAL_G
,      ACT_OUT_QTY
,      PLN_OUT_QTY
,      ACT_JOB_TIME
,      STD_QTY
,      STND_HRS_EARNED
,      STD_TIME
,      LATE_JOB
,      JOB
FROM APPS.OPI_EDW_JOB_DETAIL_V;

Dependencies

[top of page]

APPS.OPI_EDW_JOB_DETAIL_V references the following:

APPS: EDW_ITEMS_M; EDW_MTL_INVENTORY_LOC_M; EDW_MTL_UOM_M; EDW_OPI_PRDL_M; EDW_TIME_M; OPI_EDW_JOB_DETAIL_F

APPS.OPI_EDW_JOB_DETAIL_V is not referenced by any database object