DBA Data[Home] [Help] [Dependency Information]

TABLE: OPI.OPI_DBI_JOBS_TXN_STG

Object Details
Object Name: OPI_DBI_JOBS_TXN_STG
Object Type: TABLE
Owner: OPI
Subobject Name:
Status: VALID


Staging table for jobs transactions.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
JOB_ID NUMBER

Job Id.
JOB_TYPE NUMBER

1-Discrete Jobs 2-Repetetive Schedules 3-Flow Schedules 4-OPM Batches
ORGANIZATION_ID NUMBER

Organization Identifier.
ASSEMBLY_ITEM_ID NUMBER

Assembly Item Identifier.
COMPONENT_ITEM_ID NUMBER

Component Item Identifier.
UOM_CODE VARCHAR2 (3)
UOM Code.
LINE_TYPE NUMBER

1 Ingredient 2 By Product 1 Product
TRANSACTION_DATE DATE

Transaction Date.
PRIMARY_QUANTITY NUMBER

Primary Transaction quantity. Includes transaction in final mode for OPM.
PRIMARY_QUANTITY_DRAFT NUMBER

Transaction Value in base currency. Includes transaction in final mode for OPM
TRANSACTION_VALUE_B NUMBER

Primary Transaction quantity in draft mode for OPM transactions. Will have 0 for ODM transactions.
TRANSACTION_VALUE_DRAFT_B NUMBER

Transaction Value in base currency in draft mode for OPM transactions. Will have 0 for ODM transactions.
SCRAP_REASON NUMBER

Reason specified in a scrap transaction. Applies only to ODM transactions.
PLANNED_ITEM VARCHAR2 (1)
Flag indicating Planned / Non-Planned item.
ETL_TYPE_ID NUMBER

1.MU 2.WIP COMP 3.SCRAP
SOURCE NUMBER

1.ODM 2. R12 OPM 3. Pre R12 OPM
CREATION_DATE DATE

Who Column.
LAST_UPDATE_DATE DATE

Who Column.
CREATED_BY NUMBER

Who Column.
LAST_UPDATED_BY NUMBER

Who Column.
LAST_UPDATE_LOGIN NUMBER

Who Column.
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 JOB_ID
,      JOB_TYPE
,      ORGANIZATION_ID
,      ASSEMBLY_ITEM_ID
,      COMPONENT_ITEM_ID
,      UOM_CODE
,      LINE_TYPE
,      TRANSACTION_DATE
,      PRIMARY_QUANTITY
,      PRIMARY_QUANTITY_DRAFT
,      TRANSACTION_VALUE_B
,      TRANSACTION_VALUE_DRAFT_B
,      SCRAP_REASON
,      PLANNED_ITEM
,      ETL_TYPE_ID
,      SOURCE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM OPI.OPI_DBI_JOBS_TXN_STG;

Dependencies

[top of page]

OPI.OPI_DBI_JOBS_TXN_STG does not reference any database object

OPI.OPI_DBI_JOBS_TXN_STG is referenced by following:

SchemaAPPS
SynonymOPI_DBI_JOBS_TXN_STG