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

TABLE: BOM.CST_WIP_VALUE_HISTORY

Object Details
Object Name: CST_WIP_VALUE_HISTORY
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_WIP_VALUE_HISTORY
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_WIP_VALUE_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
ColumnTRANSACTION_SOURCE_CODE
CST_WIP_VALUE_HISTORY_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_ENTITY_ID
ColumnREPETITIVE_SCHEDULE_ID
ColumnTRANSACTION_DATE
ColumnTRANSACTION_ID
ColumnTRANSACTION_SOURCE_CODE
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Transaction identifier
TRANSACTION_SOURCE_CODE NUMBER
Yes Transaction source code
TRANSACTION_DATE DATE

Transaction date
WIP_ENTITY_ID NUMBER
Yes WIP job or schedule identifier
REPETITIVE_SCHEDULE_ID NUMBER

WIP repetitive schedule identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
ORGANIZATION_ID NUMBER
Yes Organization identifier
CLASS_TYPE NUMBER
Yes Accounting class type
PRIOR_TL_RESOURCE_IN NUMBER

Prior this level resource value put into the job or schedule
PRIOR_TL_OVERHEAD_IN NUMBER

Prior this level overhead value put into the job or schedule
PRIOR_TL_OSP_IN NUMBER

Prior this level outside processing value put into the job or schedule
PRIOR_PL_MATERIAL_IN NUMBER

Prior previous level material value put into the job or schedule
PRIOR_PL_MATERIAL_OVERHEAD_IN NUMBER

Prior previous level material overhead value put into the job or schedule
PRIOR_PL_RESOURCE_IN NUMBER

Prior previous level resource value put into the job or schedule
PRIOR_PL_OVERHEAD_IN NUMBER

Prior previous level overhead value put into the job or schedule
PRIOR_PL_OSP_IN NUMBER

Prior previous level outside processing value put into the job or schedule
PRIOR_TL_MATERIAL_OUT NUMBER

Prior this level material value taken out of the job or schedule
PRIOR_TL_MATERIAL_OVERHEAD_OUT NUMBER

Prior this level material overhead value taken out of the job or schedule
PRIOR_TL_RESOURCE_OUT NUMBER

Prior this level resource value taken out of the job or schedule
PRIOR_TL_OVERHEAD_OUT NUMBER

Prior this level overhead value taken out of the job or schedule
PRIOR_TL_OSP_OUT NUMBER

Prior this level outside processing value taken out of the job or schedule
PRIOR_PL_MATERIAL_OUT NUMBER

Prior previous level material value taken out of the job or schedule
PRIOR_PL_MATERIAL_OVERHEAD_OUT NUMBER

Prior previous level material overhead value taken out of the job or schedule
PRIOR_PL_RESOURCE_OUT NUMBER

Prior previous level resource value taken out of the job or schedule
PRIOR_PL_OVERHEAD_OUT NUMBER

Prior previous level overhead value taken out of the job or schedule
PRIOR_PL_OSP_OUT NUMBER

Prior previous level outside processing value taken out of the job or schedule
PRIOR_TL_MATERIAL_VAR NUMBER

Prior this level material variance
PRIOR_TL_MATERIAL_OVERHEAD_VAR NUMBER

Prior this level material overhead variance
PRIOR_TL_RESOURCE_VAR NUMBER

Prior this level resource variance
PRIOR_TL_OSP_VAR NUMBER

Prior this level outside processing variance
PRIOR_TL_OVERHEAD_VAR NUMBER

Prior this level overhead variance
PRIOR_PL_MATERIAL_VAR NUMBER

Prior this level material variance
PRIOR_PL_MATERIAL_OVERHEAD_VAR NUMBER

Prior this level material overhead variance
PRIOR_PL_RESOURCE_VAR NUMBER

Prior this level resource variance
PRIOR_PL_OVERHEAD_VAR NUMBER

Prior this level outside processing variance
PRIOR_PL_OSP_VAR NUMBER

Prior this level overhead variance
PRIOR_TL_SCRAP_IN NUMBER

Prior this level scrap value put into the job or schedule
PRIOR_TL_SCRAP_OUT NUMBER

Prior this level scrap value taken out of the job or schedule
PRIOR_TL_SCRAP_VAR NUMBER

Prior this level scrap variance
NEW_TL_RESOURCE_IN NUMBER

New this level resource value put into the job or schedule
NEW_TL_OVERHEAD_IN NUMBER

New this level overhead value put into the job or schedule
NEW_TL_OSP_IN NUMBER

New this level outside processing value put into the job or schedule
NEW_PL_MATERIAL_IN NUMBER

New previous level material value put into the job or schedule
NEW_PL_MATERIAL_OVERHEAD_IN NUMBER

New previous level material overhead value put into the job or schedule
NEW_PL_RESOURCE_IN NUMBER

New previous level resource value put into the job or schedule
NEW_PL_OVERHEAD_IN NUMBER

New previous level overhead value put into the job or schedule
NEW_PL_OSP_IN NUMBER

New previous level outside processing value put into the job or schedule
NEW_TL_MATERIAL_OUT NUMBER

New this level material value taken out of the job or schedule
NEW_TL_MATERIAL_OVERHEAD_OUT NUMBER

New this level material overhead value taken out of the job or schedule
NEW_TL_RESOURCE_OUT NUMBER

New this level resource value taken out of the job or schedule
NEW_TL_OVERHEAD_OUT NUMBER

New this level overhead value taken out of the job or schedule
NEW_TL_OSP_OUT NUMBER

New this level outside processing value taken out of the job or schedule
NEW_PL_MATERIAL_OUT NUMBER

New previous level material value taken out of the job or schedule
NEW_PL_MATERIAL_OVERHEAD_OUT NUMBER

New previous level material overhead value taken out of the job or schedule
NEW_PL_RESOURCE_OUT NUMBER

New previous level resource value taken out of the job or schedule
NEW_PL_OVERHEAD_OUT NUMBER

New previous level overhead value taken out of the job or schedule
NEW_PL_OSP_OUT NUMBER

New previous level outside processing value taken out of the job or schedule
NEW_TL_MATERIAL_VAR NUMBER

New this level material variance
NEW_TL_MATERIAL_OVERHEAD_VAR NUMBER

New this level material overhead variance
NEW_TL_RESOURCE_VAR NUMBER

New this level resource variance
NEW_TL_OSP_VAR NUMBER

New this level outside processing variance
NEW_TL_OVERHEAD_VAR NUMBER

New this level overhead variance
NEW_PL_MATERIAL_VAR NUMBER

New previous level material variance
NEW_PL_MATERIAL_OVERHEAD_VAR NUMBER

New previous level material overhead variance
NEW_PL_RESOURCE_VAR NUMBER

New previous level resource variance
NEW_PL_OVERHEAD_VAR NUMBER

New previous level overhead variance
NEW_PL_OSP_VAR NUMBER

New previous level outside processing variance
NEW_TL_SCRAP_IN NUMBER

New this level scrap value put into the job or schedule
NEW_TL_SCRAP_OUT NUMBER

New this level scrap value taken out of the job or schedule
NEW_TL_SCRAP_VAR NUMBER

New this level scrap variance
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
Query Text

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


SELECT TRANSACTION_ID
,      TRANSACTION_SOURCE_CODE
,      TRANSACTION_DATE
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      CLASS_TYPE
,      PRIOR_TL_RESOURCE_IN
,      PRIOR_TL_OVERHEAD_IN
,      PRIOR_TL_OSP_IN
,      PRIOR_PL_MATERIAL_IN
,      PRIOR_PL_MATERIAL_OVERHEAD_IN
,      PRIOR_PL_RESOURCE_IN
,      PRIOR_PL_OVERHEAD_IN
,      PRIOR_PL_OSP_IN
,      PRIOR_TL_MATERIAL_OUT
,      PRIOR_TL_MATERIAL_OVERHEAD_OUT
,      PRIOR_TL_RESOURCE_OUT
,      PRIOR_TL_OVERHEAD_OUT
,      PRIOR_TL_OSP_OUT
,      PRIOR_PL_MATERIAL_OUT
,      PRIOR_PL_MATERIAL_OVERHEAD_OUT
,      PRIOR_PL_RESOURCE_OUT
,      PRIOR_PL_OVERHEAD_OUT
,      PRIOR_PL_OSP_OUT
,      PRIOR_TL_MATERIAL_VAR
,      PRIOR_TL_MATERIAL_OVERHEAD_VAR
,      PRIOR_TL_RESOURCE_VAR
,      PRIOR_TL_OSP_VAR
,      PRIOR_TL_OVERHEAD_VAR
,      PRIOR_PL_MATERIAL_VAR
,      PRIOR_PL_MATERIAL_OVERHEAD_VAR
,      PRIOR_PL_RESOURCE_VAR
,      PRIOR_PL_OVERHEAD_VAR
,      PRIOR_PL_OSP_VAR
,      PRIOR_TL_SCRAP_IN
,      PRIOR_TL_SCRAP_OUT
,      PRIOR_TL_SCRAP_VAR
,      NEW_TL_RESOURCE_IN
,      NEW_TL_OVERHEAD_IN
,      NEW_TL_OSP_IN
,      NEW_PL_MATERIAL_IN
,      NEW_PL_MATERIAL_OVERHEAD_IN
,      NEW_PL_RESOURCE_IN
,      NEW_PL_OVERHEAD_IN
,      NEW_PL_OSP_IN
,      NEW_TL_MATERIAL_OUT
,      NEW_TL_MATERIAL_OVERHEAD_OUT
,      NEW_TL_RESOURCE_OUT
,      NEW_TL_OVERHEAD_OUT
,      NEW_TL_OSP_OUT
,      NEW_PL_MATERIAL_OUT
,      NEW_PL_MATERIAL_OVERHEAD_OUT
,      NEW_PL_RESOURCE_OUT
,      NEW_PL_OVERHEAD_OUT
,      NEW_PL_OSP_OUT
,      NEW_TL_MATERIAL_VAR
,      NEW_TL_MATERIAL_OVERHEAD_VAR
,      NEW_TL_RESOURCE_VAR
,      NEW_TL_OSP_VAR
,      NEW_TL_OVERHEAD_VAR
,      NEW_PL_MATERIAL_VAR
,      NEW_PL_MATERIAL_OVERHEAD_VAR
,      NEW_PL_RESOURCE_VAR
,      NEW_PL_OVERHEAD_VAR
,      NEW_PL_OSP_VAR
,      NEW_TL_SCRAP_IN
,      NEW_TL_SCRAP_OUT
,      NEW_TL_SCRAP_VAR
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_WIP_VALUE_HISTORY;

Dependencies

[top of page]

BOM.CST_WIP_VALUE_HISTORY does not reference any database object

BOM.CST_WIP_VALUE_HISTORY is referenced by following:

SchemaAPPS
SynonymCST_WIP_VALUE_HISTORY