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: WIP.WIP_PERIOD_BALANCES

Object Details

Object Name:	WIP_PERIOD_BALANCES
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_PERIOD_BALANCES
Subobject Name:
Status:	VALID

WIP_PERIOD_BALANCES stores summary accounting information for jobs
and schedules. Each row represents job or schedule charges within a
given accounting period, and contains the summary values for
each cost element. Oracle Work in Process uses this information to
report job and schedule values and to calculate job and period
variances.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_PERIOD_BALANCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCT_PERIOD_ID ORGANIZATION_ID WIP_ENTITY_ID REPETITIVE_SCHEDULE_ID
WIP_PERIOD_BALANCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID ACCT_PERIOD_ID

Columns

Name	Datatype	Mandatory	Comments
ACCT_PERIOD_ID	NUMBER	Yes	Accounting period Identifier
WIP_ENTITY_ID	NUMBER	Yes	WIP job or repetitive assembly 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
TL_RESOURCE_IN	NUMBER		This level resource value put into the job or repetitive schedule
TL_OVERHEAD_IN	NUMBER		This level overhead value put into the job or repetitive schedule
TL_OUTSIDE_PROCESSING_IN	NUMBER		This level outside processing value put into the job or repetitive schedule
PL_MATERIAL_IN	NUMBER		Previous level material value put into the job or repetitive schedule
PL_MATERIAL_OVERHEAD_IN	NUMBER		Previous level material overhead value put into the job or repetitive schedule
PL_RESOURCE_IN	NUMBER		Previous level resource value put into the job or repetitive schedule
PL_OVERHEAD_IN	NUMBER		Previous level overhead value put into the job or repetitive schedule
PL_OUTSIDE_PROCESSING_IN	NUMBER		Previous level outside processing value put into the job or repetitive schedule
TL_MATERIAL_OUT	NUMBER		This level material value taken out of the job or repetitive schedule
TL_MATERIAL_OVERHEAD_OUT	NUMBER		This level material overhead value taken out of the job or repetitive schedule
TL_RESOURCE_OUT	NUMBER		This level resource value taken out of the job or repetitive schedule
TL_OVERHEAD_OUT	NUMBER		This level overhead value taken out of the job or repetitive schedule
TL_OUTSIDE_PROCESSING_OUT	NUMBER		This level outside processing value taken out of the job or repetitive schedule
PL_MATERIAL_OUT	NUMBER		Previous level material value taken out of the job or repetitive schedule
PL_MATERIAL_OVERHEAD_OUT	NUMBER		Previous level material overhead value taken out of the job or repetitive schedule
PL_RESOURCE_OUT	NUMBER		Previous level resource value taken out of the job or repetitive schedule
PL_OVERHEAD_OUT	NUMBER		Previous level overhead value taken out of the job or repetitive schedule
PL_OUTSIDE_PROCESSING_OUT	NUMBER		Previous level outside processing value taken out of the job or repetitive schedule
REQUEST_ID	NUMBER		Extended Who column
PROGRAM_APPLICATION_ID	NUMBER		Extended Who column
PROGRAM_ID	NUMBER		Extended Who column
PROGRAM_UPDATE_DATE	DATE		Extended Who column
TL_MATERIAL_VAR	NUMBER		This level material variance
TL_MATERIAL_OVERHEAD_VAR	NUMBER		This level material overhead variance
TL_RESOURCE_VAR	NUMBER		This level resource variance
TL_OUTSIDE_PROCESSING_VAR	NUMBER		This level outside processing variance
TL_OVERHEAD_VAR	NUMBER		This level overhead variance
PL_MATERIAL_VAR	NUMBER		Previous level material variance
PL_MATERIAL_OVERHEAD_VAR	NUMBER		Previous level material overhead variance
PL_RESOURCE_VAR	NUMBER		Previous level resource variance
PL_OVERHEAD_VAR	NUMBER		Previous level overhead variance
PL_OUTSIDE_PROCESSING_VAR	NUMBER		Previous level outside processing variance
TL_SCRAP_IN	NUMBER		This level scrap in, applicable only for WSM entities
TL_SCRAP_OUT	NUMBER		This level scrap out, applicable only for WSM entities
TL_SCRAP_VAR	NUMBER		This level scrap variance, applicable only for WSM entities

Query Text

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


SELECT ACCT_PERIOD_ID
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      CLASS_TYPE
,      TL_RESOURCE_IN
,      TL_OVERHEAD_IN
,      TL_OUTSIDE_PROCESSING_IN
,      PL_MATERIAL_IN
,      PL_MATERIAL_OVERHEAD_IN
,      PL_RESOURCE_IN
,      PL_OVERHEAD_IN
,      PL_OUTSIDE_PROCESSING_IN
,      TL_MATERIAL_OUT
,      TL_MATERIAL_OVERHEAD_OUT
,      TL_RESOURCE_OUT
,      TL_OVERHEAD_OUT
,      TL_OUTSIDE_PROCESSING_OUT
,      PL_MATERIAL_OUT
,      PL_MATERIAL_OVERHEAD_OUT
,      PL_RESOURCE_OUT
,      PL_OVERHEAD_OUT
,      PL_OUTSIDE_PROCESSING_OUT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TL_MATERIAL_VAR
,      TL_MATERIAL_OVERHEAD_VAR
,      TL_RESOURCE_VAR
,      TL_OUTSIDE_PROCESSING_VAR
,      TL_OVERHEAD_VAR
,      PL_MATERIAL_VAR
,      PL_MATERIAL_OVERHEAD_VAR
,      PL_RESOURCE_VAR
,      PL_OVERHEAD_VAR
,      PL_OUTSIDE_PROCESSING_VAR
,      TL_SCRAP_IN
,      TL_SCRAP_OUT
,      TL_SCRAP_VAR
FROM WIP.WIP_PERIOD_BALANCES;

Dependencies

[top of page]

WIP.WIP_PERIOD_BALANCES does not reference any database object

WIP.WIP_PERIOD_BALANCES is referenced by following:

WIP: WIP_PERIOD_BALANCES#