[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_JOBS_STG |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Staging Table for Jobs Master ETL.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Manufacturing Organization Id. | ||
JOB_ID | NUMBER | Yes | Discrete and Flow: WIP_Entity_Id. Repetitive Schedule: Repetitive_Schedule_Id (i.e. WIP Job Identifier). | |
JOB_TYPE | NUMBER | Yes | 1:Discrete, 2:Repetitive Schedule, 3:Flow Schedule, 4:Process. | |
STATUS | VARCHAR2 | (40) | Yes | Job Status: Cancelled, Complete - No Charges, Closed. |
COMPLETION_DATE | DATE | Job Completion/Close date. | ||
ASSEMBLY_ITEM_ID | NUMBER | Assembly Inventory Item Id. | ||
START_QUANTITY | NUMBER | Job Start Quantity. | ||
ACTUAL_QTY_COMPLETED | NUMBER | Actual Quantity of the assembly completed by the job. | ||
UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure of the assembly. | |
CONVERSION_RATE | NUMBER | Conversion Rate from Functional Currency to Global Currency for the Completion date. | ||
INCLUDE_JOB | NUMBER | Yes | 1: Include this job in the Base MV. 2: Do not include this job in the Base MV. | |
STD_REQ_FLAG | NUMBER | Yes | Flag to indicate the re-extraction of WIP Requirement Operations. 1 = Yes. 0 = No. | |
STD_RES_FLAG | NUMBER | Yes | Flag to indicate the re-extraction of WIP Standard Resource Usage. 1 = Yes. 0 = No. | |
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. | ||
JOB_NAME | VARCHAR2 | (240) | Job Name | |
LINE_TYPE | NUMBER | Line Type -1 Ingredient, 1 Co-Product, 2 By-Product | ||
SCHEDULED_COMPLETION_DATE | DATE | Sceduled Completion Date | ||
JOB_STATUS_CODE | NUMBER | Id from Job Status Dimension View | ||
JOB_START_VALUE | NUMBER | Job Start Value | ||
PROGRAM_ID | NUMBER | Who Column. | ||
PROGRAM_LOGIN_ID | NUMBER | Who Column. | ||
PROGRAM_APPLICATION_ID | NUMBER | Who Column. | ||
REQUEST_ID | NUMBER | Who Column. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, JOB_ID
, JOB_TYPE
, STATUS
, COMPLETION_DATE
, ASSEMBLY_ITEM_ID
, START_QUANTITY
, ACTUAL_QTY_COMPLETED
, UOM_CODE
, CONVERSION_RATE
, INCLUDE_JOB
, STD_REQ_FLAG
, STD_RES_FLAG
, SOURCE
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, JOB_NAME
, LINE_TYPE
, SCHEDULED_COMPLETION_DATE
, JOB_STATUS_CODE
, JOB_START_VALUE
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM OPI.OPI_DBI_JOBS_STG;
OPI.OPI_DBI_JOBS_STG does not reference any database object
OPI.OPI_DBI_JOBS_STG is referenced by following:
|
|
|