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.GME_BATCH_STEP_RESOURCES_V

Object Details

Object Name:	GME_BATCH_STEP_RESOURCES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GME.GME_BATCH_STEP_RESOURCES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Supplementary view based on table gme_batch_step_resources

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCHSTEP_RESOURCE_ID	NUMBER	(15)	Yes	Primary/surrogate key from GME_BATCHSTEP_RESOURCE_S
BATCHSTEP_ACTIVITY_ID	NUMBER	(15)	Yes	Surrogate key to the batch step line from GME_BATCH_STEP_ACTIVITIES (FK)
RESOURCES	VARCHAR2	(16)	Yes	The resource used by the operation. Defaults from GMD_OPERATION_RESOURCES. Can be added to a batch, in which case we must validate against CR_RSRC_MST.
BATCHSTEP_ID	NUMBER	(10)	Yes	Surrogate key to the batch step line from GME_BATCH_STEPS (FK)
BATCH_ID	NUMBER	(10)	Yes	Batch Identifier FK to the GME_BATCH_HEADER table.
COST_ANALYSIS_CODE	VARCHAR2	(32)	Yes	Cost analysis code, defaults from GMD_OPERATION_RESOURCES.
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Surrogate key for a cost component class, defaults from GMD_OPERATION_RESOURCES
PRIM_RSRC_IND	NUMBER	(5)	Yes	Primary resource indicator. 0 = Not primary resource, 1 = Primary resource.Defaults from GMD_OPERATION_RESOURCES
SCALE_TYPE	NUMBER	(5)	Yes	Scale type. 0 = Non-scaleable1 = Linear scaling2 = Scale by ChargeDefaults from GMD_OPERATION_RESOURCES
PLAN_RSRC_COUNT	NUMBER			Planned resource count, defaults from GMD_OPERATION_RESOURCES. Overridable, must be => 0.
ACTUAL_RSRC_COUNT	NUMBER			Actual resource count, defaults from PLAN_RSRC_COUNT, overridable during WIP or certification, must be => 0.
PLAN_RSRC_USAGE	NUMBER			Planned resource usage, defaults from GMD_RECIPES? Or GMD_OPERATION_RESOURCES. Overridable, must be => 0. Scaled based on plan_rsrc_qty and scale_type.
ACTUAL_RSRC_USAGE	NUMBER			If auto step qty is not used, this value defaults from planned resource usage. If auto step qty is used, this is based on actual_rsrc_qty and scale_type.
PLAN_RSRC_QTY	NUMBER			Planned quantity processed by the resource. From GMD_OPERATIONS_RESOURCES and scaled to batch size.
ACTUAL_RSRC_QTY	NUMBER			Actual quantity processed by the resource. Defaults to plan_rsrc_qty if auto step qty calculation is not used.
PLAN_START_DATE	DATE			Planned start date/time for this resource. Planned start date of the activity plus the offset interval.
ACTUAL_START_DATE	DATE			Actual start date/time for this resource. Null on creation. Updated when the step is released, default to activity actual start time but can be overridden at release time.
PLAN_CMPLT_DATE	DATE			Planned completion date/time for this resource. Plan start date plus planned usage.
ACTUAL_CMPLT_DATE	DATE			Actual completion date/time for this resource. Null on creation. Updated with the batch step is certified, default to the step actual completion date.
PLAN_START_DATE_DT	VARCHAR2	(4000)		Planned start date in user display format
ACTUAL_START_DATE_DT	VARCHAR2	(4000)		Actual start date in user display format
PLAN_CMPLT_DATE_DT	VARCHAR2	(4000)		Planned completion date in user display format
ACTUAL_CMPLT_DATE_DT	VARCHAR2	(4000)		Actual completion date in user display format
OFFSET_INTERVAL	NUMBER		Yes	Time offset in hours from activity start to this resource. Must be => 0
MIN_CAPACITY	NUMBER			Minimum Capacity of the resource carried forward from CR_RSRC_MST
MAX_CAPACITY	NUMBER			Maximum Capacity of the resource carried forward from CR_RSRC_MST
CALCULATE_CHARGES	NUMBER	(5)		Whether this resource should be used in Charge calculations, copied from GMD_OPERATION_RESOURCES
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
CAPACITY_TOLERANCE	NUMBER			CAPACITY_TOLERANCE from GMD_OPERATIONS_RESOURCES or overriden value from GMD_RECIPE_ORGN_RESOURCES at the time of batch creation
ORIGINAL_RSRC_QTY	NUMBER			PLAN_RSRC_QTY from GMD_OPERATIONS_RESOURCES or overriden value from GMD_RECIPE_ORGN_RESOURCES at the time of batch creation
ORIGINAL_RSRC_USAGE	NUMBER			PLAN_RSRC_USAGE from GMD_OPERATIONS_RESOURCES or overriden value from GMD_RECIPE_ORGN_RESOURCES at the time of batch creation
SEQUENCE_DEPENDENT_ID	NUMBER	(15)		Used to hold the id used by scheduling
SEQUENCE_DEPENDENT_USAGE	NUMBER			Amount of usage that is associated to sequence dependent transactions
FIRM_TYPE	NUMBER			Indicates the level of firming that will be applied by APS engine when scheduling
GROUP_SEQUENCE_ID	NUMBER			Used to group the sequence together
GROUP_SEQUENCE_NUMBER	NUMBER			Used to number the Step Resource in the group defined by the group_Sequence_id
ORGANIZATION_ID	NUMBER			To identify the organization (Plant /Lab)
CAPACITY_UM	VARCHAR2	(3)		Capacity UOM
USAGE_UM	VARCHAR2	(3)		Usage UOM
RESOURCE_QTY_UM	VARCHAR2	(3)		Resource Quantity UOM
RESOURCE_DESC	VARCHAR2	(240)	Yes	Resource Description

Query Text

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


SELECT BATCHSTEP_RESOURCE_ID
,      BATCHSTEP_ACTIVITY_ID
,      RESOURCES
,      BATCHSTEP_ID
,      BATCH_ID
,      COST_ANALYSIS_CODE
,      COST_CMPNTCLS_ID
,      PRIM_RSRC_IND
,      SCALE_TYPE
,      PLAN_RSRC_COUNT
,      ACTUAL_RSRC_COUNT
,      PLAN_RSRC_USAGE
,      ACTUAL_RSRC_USAGE
,      PLAN_RSRC_QTY
,      ACTUAL_RSRC_QTY
,      PLAN_START_DATE
,      ACTUAL_START_DATE
,      PLAN_CMPLT_DATE
,      ACTUAL_CMPLT_DATE
,      PLAN_START_DATE_DT
,      ACTUAL_START_DATE_DT
,      PLAN_CMPLT_DATE_DT
,      ACTUAL_CMPLT_DATE_DT
,      OFFSET_INTERVAL
,      MIN_CAPACITY
,      MAX_CAPACITY
,      CALCULATE_CHARGES
,      TEXT_CODE
,      CAPACITY_TOLERANCE
,      ORIGINAL_RSRC_QTY
,      ORIGINAL_RSRC_USAGE
,      SEQUENCE_DEPENDENT_ID
,      SEQUENCE_DEPENDENT_USAGE
,      FIRM_TYPE
,      GROUP_SEQUENCE_ID
,      GROUP_SEQUENCE_NUMBER
,      ORGANIZATION_ID
,      CAPACITY_UM
,      USAGE_UM
,      RESOURCE_QTY_UM
,      RESOURCE_DESC
FROM APPS.GME_BATCH_STEP_RESOURCES_V;

Dependencies

[top of page]

APPS.GME_BATCH_STEP_RESOURCES_V references the following:

APPS: CR_RSRC_MST; FND_DATE - show dependent code; FND_TIMEZONES - show dependent code; GME_BATCH_STEP_RESOURCES

APPS.GME_BATCH_STEP_RESOURCES_V is not referenced by any database object