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_EFC

Object Details

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

EURO as a functional currency table for WIP_PERIOD_BALANCES.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	20
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
TL_OUTSIDE_PROCESSING_VAR	NUMBER		Tl Outside Processing Var
PL_OVERHEAD_OUT	NUMBER		Pl Overhead Out
TL_OVERHEAD_OUT	NUMBER		Tl Overhead Out
PL_OUTSIDE_PROCESSING_IN	NUMBER		Pl Outside Processing In
PL_RESOURCE_VAR	NUMBER		Pl Resource Var
PL_OUTSIDE_PROCESSING_OUT	NUMBER		Pl Outside Processing Out
PL_MATERIAL_OVERHEAD_IN	NUMBER		Pl Material Overhead In
TL_OUTSIDE_PROCESSING_IN	NUMBER		Tl Outside Processing In
TL_RESOURCE_VAR	NUMBER		Tl Resource Var
TL_OUTSIDE_PROCESSING_OUT	NUMBER		Tl Outside Processing Out
PL_MATERIAL_VAR	NUMBER		Pl Material Var
TL_MATERIAL_VAR	NUMBER		Tl Material Var
REPETITIVE_SCHEDULE_ID	NUMBER		Repetitive Schedule Identifier
PL_RESOURCE_OUT	NUMBER		Pl Resource Out
TL_RESOURCE_OUT	NUMBER		Tl Resource Out
PL_MATERIAL_OVERHEAD_VAR	NUMBER		Pl Material Overhead Var
PL_OVERHEAD_IN	NUMBER		Pl Overhead In
PL_MATERIAL_IN	NUMBER		Pl Material In
PL_MATERIAL_OUT	NUMBER		Pl Material Out
TL_OVERHEAD_IN	NUMBER		Tl Overhead In
TL_MATERIAL_OVERHEAD_VAR	NUMBER		Tl Material Overhead Var
TL_MATERIAL_OUT	NUMBER		Tl Material Out
ACCT_PERIOD_ID	NUMBER	Yes	Accounting Period Identifier
PL_MATERIAL_OVERHEAD_OUT	NUMBER		Pl Material Overhead Out
TL_SCRAP_IN	NUMBER		Tl Scrap In
TL_SCRAP_OUT	NUMBER		Tl Scrap Out
PL_OVERHEAD_VAR	NUMBER		Pl Overhead Var
TL_MATERIAL_OVERHEAD_OUT	NUMBER		Tl Material Overhead Out
TL_OVERHEAD_VAR	NUMBER		Tl Overhead Var
WIP_ENTITY_ID	NUMBER	Yes	WIP Entity Identifier
PL_RESOURCE_IN	NUMBER		Pl Resource In
PL_OUTSIDE_PROCESSING_VAR	NUMBER		Pl Outside Processing Var
TL_RESOURCE_IN	NUMBER		Tl Resource In
SET_OF_BOOKS_ID	NUMBER		Set of Books Identifier

Query Text

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


SELECT TL_OUTSIDE_PROCESSING_VAR
,      PL_OVERHEAD_OUT
,      TL_OVERHEAD_OUT
,      PL_OUTSIDE_PROCESSING_IN
,      PL_RESOURCE_VAR
,      PL_OUTSIDE_PROCESSING_OUT
,      PL_MATERIAL_OVERHEAD_IN
,      TL_OUTSIDE_PROCESSING_IN
,      TL_RESOURCE_VAR
,      TL_OUTSIDE_PROCESSING_OUT
,      PL_MATERIAL_VAR
,      TL_MATERIAL_VAR
,      REPETITIVE_SCHEDULE_ID
,      PL_RESOURCE_OUT
,      TL_RESOURCE_OUT
,      PL_MATERIAL_OVERHEAD_VAR
,      PL_OVERHEAD_IN
,      PL_MATERIAL_IN
,      PL_MATERIAL_OUT
,      TL_OVERHEAD_IN
,      TL_MATERIAL_OVERHEAD_VAR
,      TL_MATERIAL_OUT
,      ACCT_PERIOD_ID
,      PL_MATERIAL_OVERHEAD_OUT
,      TL_SCRAP_IN
,      TL_SCRAP_OUT
,      PL_OVERHEAD_VAR
,      TL_MATERIAL_OVERHEAD_OUT
,      TL_OVERHEAD_VAR
,      WIP_ENTITY_ID
,      PL_RESOURCE_IN
,      PL_OUTSIDE_PROCESSING_VAR
,      TL_RESOURCE_IN
,      SET_OF_BOOKS_ID
FROM WIP.WIP_PERIOD_BALANCES_EFC;

Dependencies

[top of page]

WIP.WIP_PERIOD_BALANCES_EFC does not reference any database object

WIP.WIP_PERIOD_BALANCES_EFC is referenced by following:

APPS: WIP_PERIOD_BALANCES_EFC