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]

VIEW: APPS.WIPFV_WIP_PERIOD_BALANCES

Object Details

Object Name:	WIPFV_WIP_PERIOD_BALANCES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIPFV_WIP_PERIOD_BALANCES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows summary accounting information for jobs and schedules and includes job or schedule charges within an accounting period as well as the summary values for each cost element.

[View Source]

Columns

Name	Datatype	Length	Mandatory
PERIOD_NAME	VARCHAR2	(15)	Yes
MFG_ORDER_NAME	VARCHAR2	(240)	Yes
_LA:ACCOUNTING_CLASS	CHAR	(52)
WIP_RESOURCE_CHARGED	NUMBER
WIP_OVERHEAD_CHARGED	NUMBER
WIP_OUTSIDE_PROCESS_CHARGED	NUMBER
COMPONENT_MATERIAL_CHARGED	NUMBER
COMPONENT_MATL_OVHD_CHARGED	NUMBER
COMPONENT_RESOURCE_CHARGED	NUMBER
COMPONENT_OVERHEAD_CHARGED	NUMBER
COMPONENT_OUT_PROCESS_CHARGED	NUMBER
WIP_MATERIAL_RELIEVED	NUMBER
WIP_MATL_OVHD_RELIEVED	NUMBER
WIP_RESOURCE_RELIEVED	NUMBER
WIP_OVERHEAD_RELIEVED	NUMBER
WIP_OUTSIDE_PROCESS_RELIEVED	NUMBER
COMPONENT_MATERIAL_RELIEVED	NUMBER
COMPONENT_MATL_OVHD_RELIEVED	NUMBER
COMPONENT_RESOURCE_RELIEVED	NUMBER
COMPONENT_OVERHEAD_RELIEVED	NUMBER
COMPONENT_OUT_PROCESS_RELIEVED	NUMBER
WIP_MATERIAL_VARIANCE	NUMBER
WIP_MATL_OVHD_VARIANCE	NUMBER
WIP_RESOURCE_VARIANCE	NUMBER
WIP_OUTSIDE_PROCESS_VARIANCE	NUMBER
WIP_OVERHEAD_VARIANCE	NUMBER
COMPONENT_MATERIAL_VARIANCE	NUMBER
COMPONENT_MATL_OVHD_VARIANCE	NUMBER
COMPONENT_RESOURCE_VARIANCE	NUMBER
COMPONENT_OVERHEAD_VARIANCE	NUMBER
COMPONENT_OUT_PROCESS_VARIANCE	NUMBER
ORGANIZATION_CODE	VARCHAR2	(3)
ORGANIZATION_NAME	VARCHAR2	(240)	Yes
ACCOUNT_PERIOD_ID	NUMBER		Yes
WIP_ENTITY_ID	NUMBER		Yes
REPETITIVE_SCHEDULE_ID	NUMBER
ORGANIZATION_ID	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes

Query Text

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


SELECT PERIOD_NAME
,      MFG_ORDER_NAME
,      _LA:ACCOUNTING_CLASS
,      WIP_RESOURCE_CHARGED
,      WIP_OVERHEAD_CHARGED
,      WIP_OUTSIDE_PROCESS_CHARGED
,      COMPONENT_MATERIAL_CHARGED
,      COMPONENT_MATL_OVHD_CHARGED
,      COMPONENT_RESOURCE_CHARGED
,      COMPONENT_OVERHEAD_CHARGED
,      COMPONENT_OUT_PROCESS_CHARGED
,      WIP_MATERIAL_RELIEVED
,      WIP_MATL_OVHD_RELIEVED
,      WIP_RESOURCE_RELIEVED
,      WIP_OVERHEAD_RELIEVED
,      WIP_OUTSIDE_PROCESS_RELIEVED
,      COMPONENT_MATERIAL_RELIEVED
,      COMPONENT_MATL_OVHD_RELIEVED
,      COMPONENT_RESOURCE_RELIEVED
,      COMPONENT_OVERHEAD_RELIEVED
,      COMPONENT_OUT_PROCESS_RELIEVED
,      WIP_MATERIAL_VARIANCE
,      WIP_MATL_OVHD_VARIANCE
,      WIP_RESOURCE_VARIANCE
,      WIP_OUTSIDE_PROCESS_VARIANCE
,      WIP_OVERHEAD_VARIANCE
,      COMPONENT_MATERIAL_VARIANCE
,      COMPONENT_MATL_OVHD_VARIANCE
,      COMPONENT_RESOURCE_VARIANCE
,      COMPONENT_OVERHEAD_VARIANCE
,      COMPONENT_OUT_PROCESS_VARIANCE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      ACCOUNT_PERIOD_ID
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      ORGANIZATION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.WIPFV_WIP_PERIOD_BALANCES;

Dependencies

[top of page]

APPS.WIPFV_WIP_PERIOD_BALANCES references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; MTL_PARAMETERS; ORG_ACCT_PERIODS; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_PERIOD_BALANCES; WIP_REPETITIVE_SCHEDULES

APPS.WIPFV_WIP_PERIOD_BALANCES is not referenced by any database object