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_EDW_JOB_RSRC_FSTG

Object Details

Object Name:	OPI_EDW_JOB_RSRC_FSTG
Object Type:	TABLE
Owner:	OPI
FND Design Data:	OPI.OPI_EDW_JOB_RSRC_FSTG
Subobject Name:
Status:	VALID

Interface table for the Job Resource Fact. This will be the staging area for data coming into the Warehouse from Discrete and Process Manufacturing sources.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ACTIVITY_FK	VARCHAR2	(40)	Foreign Key to Activity Dimension.
ACTIVITY_FK_KEY	NUMBER		Foreign Key to Activity Dimension.
ACT_CMPL_DATE	DATE		Actual completion date of the Job step (Operation).
ACT_RSRC_COUNT	NUMBER		Actual resource count used in the Batch step.Currently 0 for Discrete Manufacturing sources.
ACT_RSRC_QTY	NUMBER		Actual quantity processed by the resource
ACT_RSRC_USAGE	NUMBER		Actual resource usage.
ACT_RSRC_USAGE_VAL_B	NUMBER		Actual resource usage value in Set Of Books currency.
ACT_RSRC_USAGE_VAL_G	NUMBER		Actual resource usage value in Warehouse currency.
ACT_RSRC_VAL_B	NUMBER		Actual value of the item processed by the resource, in Set Of Books currency, calculated by (Processed quantity * Cost). Currently 0 for Discrete manufacturing sources.
ACT_RSRC_VAL_G	NUMBER		Actual value of the item processed by the resource, in Warehouse currency, calculated by (Processed quantity * Cost). Currently 0 for Discrete manufacturing sources.
ACT_STRT_DATE	DATE		Actual start date of the Job step (Operation).
AVL_RSRC	NUMBER		Available resource.
COLLECTION_DATE	DATE		Date column populated by the Load program.
COLLECTION_STATUS	VARCHAR2	(30)	Status column populated by the Load program.
CREATION_DATE	DATE		Standard who column.
DEPARTMENT	VARCHAR2	(80)	Department code.
ERROR_CODE	VARCHAR2	(2000)	Error code column populated by the Load program.
EXTD_RSRC_COST	NUMBER		Extended Resource Cost. Currently 0 for Discrete Manufacturing sources.
INSTANCE_FK	VARCHAR2	(80)	Foreign Key to Instance Dimension.
INSTANCE_FK_KEY	NUMBER		Foreign Key to Instance Dimension.
ITEM_FK	VARCHAR2	(240)	Foreign Key to Item Dimension -Item Organization Level (This is the product produced by the resource)
ITEM_FK_KEY	NUMBER		Foreign Key to Item Dimension -Item Organization Level (This is the product produced by the resource)
JOB_NO	VARCHAR2	(80)	Job/Batch Number.
JOB_RSRC_PK	VARCHAR2	(240)	User defined Primary Key. This will have the structure of PRODTAG is either OPM or OPI depending on whether OPM or OPI extracted the row.
JOB_RSRC_PK_KEY	NUMBER		Generated Surrogate Key
LOCATOR_FK	VARCHAR2	(240)	Foreign Key to Inventory Location Dimension - Inventory Org group level for Process Mfg sources and Inventory Org Level for Discrete Mfg sources. Based on the Organization where the Job/Batch is executed.
LOCATOR_FK_KEY	NUMBER		Foreign Key to Inventory Location Dimension - Inventory Org group level for Process Mfg sources and Inventory Org Level for Discrete Mfg sources. Based on the Organization where the Job/Batch is executed.
OPERATION_CODE	VARCHAR2	(30)	Operation code column populated by the Load program.
OPERATION_SEQ_NO	VARCHAR2	(80)	Operations step in the job.
OPRN_FK	VARCHAR2	(40)	Foreign Key to Operation Dimension - Operation level.
OPRN_FK_KEY	NUMBER		Foreign Key to Operation Dimension - Operation level.
PLN_CMPL_DATE	DATE		Planned completion date of the Job step (Operation).
PLN_RSRC_COUNT	NUMBER		Planned resource count.Currently 0 for Discrete Manufacturing sources.
PLN_RSRC_QTY	NUMBER		Planned resource quantity processed by the resource
PLN_RSRC_USAGE	NUMBER		Planned resource usage.
PLN_RSRC_USAGE_VAL_B	NUMBER		Planned resource usage value in Set Of Books currency.
PLN_RSRC_USAGE_VAL_G	NUMBER		Planned resource usage value in Warehouse currency.
PLN_RSRC_VAL_B	NUMBER		Planned value of the item processed by the resource, in Set Of Books currency , calculated by (Planned quantity * Cost). Currently 0 for Discrete Manufacturing sources.
PLN_RSRC_VAL_G	NUMBER		Planned value of the item processed by the resource, in Warehouse currency , calculated by (Planned quantity * Cost). Currently 0 for Discrete Manufacturing sources.
PLN_STRT_DATE	DATE		Planned start date of the Job step (Operation).
QTY_UOM_FK	VARCHAR2	(80)	Foreign Key to Unit Of Measure Dimension for measuring quantity.
QTY_UOM_FK_KEY	NUMBER		Foreign Key to Unit Of Measure Dimension for measuring quantity.
REQUEST_ID	NUMBER		Request Id column populated by the Load program.
RSRC_FK	VARCHAR2	(80)	Foreign Key to Resource Dimension - Resource level.
RSRC_FK_KEY	NUMBER		Foreign Key to Resource Dimension - Resource level.
SOB_CURRENCY_FK	VARCHAR2	(80)	Foreign Key to Currency Dimension for Set Of Books Currency.
SOB_CURRENCY_FK_KEY	NUMBER		Foreign Key to Currency Dimension for Set Of Books Currency.
TRX_DATE_FK	VARCHAR2	(80)	Foreign Key to Time Dimension - Calendar Day level.Based on Actual completion date of the Job step (operation).
TRX_DATE_FK_KEY	NUMBER		Foreign Key to Time Dimension - Calendar Day level.Based on Actual completion date of the Job step (operation).
USAGE_UOM_FK	VARCHAR2	(80)	Foreign Key to Unit Of Measure Dimension .Based on Resource Usage UOM.
USAGE_UOM_FK_KEY	NUMBER		Foreign Key to Unit Of Measure Dimension .Based on Resource Usage UOM.
USER_ATTRIBUTE1	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE10	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE11	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE12	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE13	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE14	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE15	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE2	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE3	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE4	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE5	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE6	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE7	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE8	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE9	VARCHAR2	(240)	User defined attribute
USER_FK1	VARCHAR2	(240)	User defined Foreign Key to a Dimension.
USER_FK1_KEY	NUMBER		User defined Foreign Key to a Dimension.
USER_FK2	VARCHAR2	(240)	User defined Foreign Key to a Dimension.
USER_FK2_KEY	NUMBER		User defined Foreign Key to a Dimension.
USER_FK3	VARCHAR2	(240)	User defined Foreign Key to a Dimension.
USER_FK3_KEY	NUMBER		User defined Foreign Key to a Dimension.
USER_FK4	VARCHAR2	(240)	User defined Foreign Key to a Dimension.
USER_FK4_KEY	NUMBER		User defined Foreign Key to a Dimension.
USER_FK5	VARCHAR2	(240)	User defined Foreign Key to a Dimension.
USER_FK5_KEY	NUMBER		User defined Foreign Key to a Dimension.
USER_MEASURE1	NUMBER		User defined measure
USER_MEASURE2	NUMBER		User defined measure
USER_MEASURE3	NUMBER		User defined measure
USER_MEASURE4	NUMBER		User defined measure
USER_MEASURE5	NUMBER		User defined measure
ROW_ID	VARCHAR2	(30)	Row id column used by Load program.
LAST_UPDATE_DATE	DATE		Standard who column.
STND_RSRC_USAGE	NUMBER		Standard resource usage, calculated as (Planned resource usage/Planned quantity produced) *Actual quantity produced.

Query Text

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


SELECT ACTIVITY_FK
,      ACTIVITY_FK_KEY
,      ACT_CMPL_DATE
,      ACT_RSRC_COUNT
,      ACT_RSRC_QTY
,      ACT_RSRC_USAGE
,      ACT_RSRC_USAGE_VAL_B
,      ACT_RSRC_USAGE_VAL_G
,      ACT_RSRC_VAL_B
,      ACT_RSRC_VAL_G
,      ACT_STRT_DATE
,      AVL_RSRC
,      COLLECTION_DATE
,      COLLECTION_STATUS
,      CREATION_DATE
,      DEPARTMENT
,      ERROR_CODE
,      EXTD_RSRC_COST
,      INSTANCE_FK
,      INSTANCE_FK_KEY
,      ITEM_FK
,      ITEM_FK_KEY
,      JOB_NO
,      JOB_RSRC_PK
,      JOB_RSRC_PK_KEY
,      LOCATOR_FK
,      LOCATOR_FK_KEY
,      OPERATION_CODE
,      OPERATION_SEQ_NO
,      OPRN_FK
,      OPRN_FK_KEY
,      PLN_CMPL_DATE
,      PLN_RSRC_COUNT
,      PLN_RSRC_QTY
,      PLN_RSRC_USAGE
,      PLN_RSRC_USAGE_VAL_B
,      PLN_RSRC_USAGE_VAL_G
,      PLN_RSRC_VAL_B
,      PLN_RSRC_VAL_G
,      PLN_STRT_DATE
,      QTY_UOM_FK
,      QTY_UOM_FK_KEY
,      REQUEST_ID
,      RSRC_FK
,      RSRC_FK_KEY
,      SOB_CURRENCY_FK
,      SOB_CURRENCY_FK_KEY
,      TRX_DATE_FK
,      TRX_DATE_FK_KEY
,      USAGE_UOM_FK
,      USAGE_UOM_FK_KEY
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_FK1
,      USER_FK1_KEY
,      USER_FK2
,      USER_FK2_KEY
,      USER_FK3
,      USER_FK3_KEY
,      USER_FK4
,      USER_FK4_KEY
,      USER_FK5
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      ROW_ID
,      LAST_UPDATE_DATE
,      STND_RSRC_USAGE
FROM OPI.OPI_EDW_JOB_RSRC_FSTG;

Dependencies

[top of page]

OPI.OPI_EDW_JOB_RSRC_FSTG does not reference any database object

OPI.OPI_EDW_JOB_RSRC_FSTG is referenced by following:

APPS: OPI_EDW_JOB_RSRC_FSTG