[Home] [Help] [Dependency Information]
Object Name: | OPI_EDW_OPI_JOB_RSRC_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OPI.OPI_EDW_OPI_JOB_RSRC_FCV |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the source view for extracting Job Resource information from OPI sources.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VIEW_ID | NUMBER | View Identifier. | ||
SEQ_ID | NUMBER | Surrogate key for the sequence. | ||
JOB_RSRC_PK | VARCHAR2 | (239) | Primary key for job resource record. | |
ACT_RSRC_COUNT | NUMBER | Actual resource count used in the batch step. | ||
PLN_RSRC_COUNT | NUMBER | Planned resource count. | ||
ACT_RSRC_QTY | NUMBER | Actual resource quantity. | ||
ACT_RSRC_VAL_B | NUMBER | Actual resource usage value in set of books. | ||
ACT_RSRC_VAL_G | NUMBER | Actual resource usage value in warehouse currency. | ||
PLN_RSRC_QTY | NUMBER | Planned resource quantity. | ||
PLN_RSRC_VAL_B | NUMBER | Planned resource usage value in set of books. | ||
PLN_RSRC_VAL_G | NUMBER | Planned resource usage value in warehouse currency. | ||
ACT_RSRC_USAGE | NUMBER | Planned resource usage value in warehouse currency. | ||
PLN_RSRC_USAGE | NUMBER | Planned resource usage. | ||
STND_RSRC_USAGE | NUMBER | Standard resource usage is (planned resource usage / planned quantity produced) * actual quantity produced. | ||
ACT_RSRC_USAGE_VAL_B | NUMBER | Actual resource usage value in set of books. | ||
ACT_RSRC_USAGE_VAL_G | NUMBER | Actual resource usage value in warehouse currency. | ||
PLN_RSRC_USAGE_VAL_B | NUMBER | Planned resource usage value in set of books. | ||
PLN_RSRC_USAGE_VAL_G | NUMBER | Planned resource usage value in warehouse currency. | ||
EXTD_RSRC_COST | NUMBER | Extended resource cost. | ||
JOB_NO | VARCHAR2 | (240) | Code for the job. | |
OPERATION_SEQ_NO | NUMBER | Sequence identifier for the operations. | ||
DEPARTMENT | VARCHAR2 | (10) | Department name. | |
ACT_STRT_DATE | DATE | Actual start date. | ||
ACT_CMPL_DATE | DATE | Actual completed date. | ||
PLN_STRT_DATE | DATE | Planned start date. | ||
PLN_CMPL_DATE | DATE | Planned completed date. | ||
SOB_CURRENCY_FK | VARCHAR2 | (4000) | Foreign key on the currency dimension for the set of books currency. | |
QTY_UOM_FK | VARCHAR2 | (4000) | Foreign key on the unit of measure dimension for measuring quantity. | |
INSTANCE_FK | VARCHAR2 | (30) | Foreign key on the instance dimension. | |
LOCATOR_FK | VARCHAR2 | (4000) | Foreign key on the inventory location dimension - based on the organization where the job / batch is executed. | |
ACTIVITY_FK | VARCHAR2 | (75) | Foreign key on the activity dimension. | |
TRX_DATE_FK | VARCHAR2 | (4000) | Foreign key on the time dimension - calendar day level. Based on actual completion date of the job step (operation). | |
OPRN_FK | VARCHAR2 | (116) | Foreign key on the operation dimension - operation level. | |
RSRC_FK | VARCHAR2 | (4000) | Foreign key on the resource dimension - resource level. | |
ITEM_FK | VARCHAR2 | (4000) | Foreign key on the item dimension - item organization level (This is the product produced by the resource). | |
USAGE_UOM_FK | VARCHAR2 | (4000) | Foreign key on the unit of measure dimension. Based on resource usage UOM. | |
GLOBAL_CURRENCY_RATE | NUMBER | Global currency rate. |
Cut, paste (and edit) the following text to query this object:
SELECT VIEW_ID
, SEQ_ID
, JOB_RSRC_PK
, ACT_RSRC_COUNT
, PLN_RSRC_COUNT
, ACT_RSRC_QTY
, ACT_RSRC_VAL_B
, ACT_RSRC_VAL_G
, PLN_RSRC_QTY
, PLN_RSRC_VAL_B
, PLN_RSRC_VAL_G
, ACT_RSRC_USAGE
, PLN_RSRC_USAGE
, STND_RSRC_USAGE
, ACT_RSRC_USAGE_VAL_B
, ACT_RSRC_USAGE_VAL_G
, PLN_RSRC_USAGE_VAL_B
, PLN_RSRC_USAGE_VAL_G
, EXTD_RSRC_COST
, JOB_NO
, OPERATION_SEQ_NO
, DEPARTMENT
, ACT_STRT_DATE
, ACT_CMPL_DATE
, PLN_STRT_DATE
, PLN_CMPL_DATE
, SOB_CURRENCY_FK
, QTY_UOM_FK
, INSTANCE_FK
, LOCATOR_FK
, ACTIVITY_FK
, TRX_DATE_FK
, OPRN_FK
, RSRC_FK
, ITEM_FK
, USAGE_UOM_FK
, GLOBAL_CURRENCY_RATE
FROM APPS.OPI_EDW_OPI_JOB_RSRC_FCV;
|
|
|