Results for “prim_rsrc_ind”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GME_BATCH_STEP_RESOURCES_V is a supplementary view owned by the APPS schema in Oracle EBS 12.1.1 and 12.2.2, defined in the Process Manufacturing Process Execution (GME) module. It is built on the gme_batch_step_resources base table and exposes resource assignments at the batch step level, joined to the resource master to supply descriptive text. The view adds display-formatted date columns derived through FND_DATE and FND_TIMEZONES, making it suitable for operational reporting, batch execution inquiries, and integration extracts where resource consumption, capacity limits, and scheduling data are needed for a manufacturing batch.
Because the view is marked VALID and its referenced objects include package calls (FND_DATE, FND_TIMEZONES), consumers should treat it as a reporting and inquiry layer rather than a transactional interface. The presence of the MIN_CAPACITY and MAX_CAPACITY columns is directly relevant to users searching on "min_capacity," as these fields express the lower and upper capacity bounds defined for a resource within a batch step.
Underlying Base Objects
The view is defined over the following documented base objects:
- GME_BATCH_STEP_RESOURCES (SYNONYM) — the primary source of all resource-level attribute columns, aliased GBSR in the view text.
- CR_RSRC_MST (SYNONYM) — joined on RESOURCES to provide RESOURCE_DESC.
- FND_DATE (PACKAGE) — supplies DATE_TO_DISPLAYDT for converting stored dates into display format.
- FND_TIMEZONES (PACKAGE) — supplies GET_SERVER_TIMEZONE_CODE, used as the conversion argument.
The join condition is CRM.RESOURCES = GBSR.RESOURCES, meaning every row returns a batch step resource record enriched with its master resource description. Four derived date columns are produced by wrapping PLAN_START_DATE, ACTUAL_START_DATE, PLAN_CMPLT_DATE, and ACTUAL_CMPLT_DATE in FND_DATE.DATE_TO_DISPLAYDT using the server time zone code.
Key Columns
- BATCHSTEP_RESOURCE_ID / BATCHSTEP_ACTIVITY_ID / BATCHSTEP_ID — keys identifying the resource assignment, its activity, and its parent batch step.
- BATCH_ID / ORGANIZATION_ID — links the record to the batch and the inventory organization.
- RESOURCES / RESOURCE_DESC — resource identifier and its descriptive text from CR_RSRC_MST.
- MIN_CAPACITY / MAX_CAPACITY / CAPACITY_TOLERANCE / CAPACITY_UM — capacity bounds and tolerance for the resource, with unit of measure.
- PLAN_RSRC_COUNT / ACTUAL_RSRC_COUNT, PLAN_RSRC_USAGE / ACTUAL_RSRC_USAGE, PLAN_RSRC_QTY / ACTUAL_RSRC_QTY — planned versus actual resource counts, usages, and quantities.
- PLAN_START_DATE, ACTUAL_START_DATE, PLAN_CMPLT_DATE, ACTUAL_CMPLT_DATE — raw dates, plus corresponding
_DTdisplay-formatted columns. - PRIM_RSRC_IND, SCALE_TYPE, OFFSET_INTERVAL, CALCULATE_CHARGES, FIRM_TYPE, TEXT_CODE — resource behavior and scheduling attributes.
- GROUP_SEQUENCE_ID / GROUP_SEQUENCE_NUMBER, SEQUENCE_DEPENDENT_ID / SEQUENCE_DEPENDENT_USAGE — grouping and sequence dependency information.
Common Use Cases and Queries
Typical scenarios include batch resource inquiry screens, capacity validation reports, and extract programs feeding scheduling or cost analysis. The MIN_CAPACITY column is frequently queried to identify resources whose lower capacity bound must be respected during execution.
Example: retrieve capacity-bound resources for a batch.
SELECT BATCH_ID, RESOURCES, RESOURCE_DESC, MIN_CAPACITY, MAX_CAPACITY, CAPACITY_UMFROM APPS.GME_BATCH_STEP_RESOURCES_VWHERE BATCH_ID = :p_batch_idORDER BY BATCHSTEP_ID;
Example: compare planned and actual usage with capacity limits.
SELECT BATCHSTEP_RESOURCE_ID, RESOURCES, PLAN_RSRC_USAGE, ACTUAL_RSRC_USAGE, MIN_CAPACITY, MAX_CAPACITYFROM APPS.GME_BATCH_STEP_RESOURCES_VWHERE ORGANIZATION_ID = :p_org_idAND ACTUAL_RSRC_USAGE > MIN_CAPACITY;
Because the view calls FND_DATE and FND_TIMEZONES per row, queries spanning large batch ranges should be filtered on BATCH_ID or ORGANIZATION_ID to limit the display-date conversion overhead.
-
Supplementary view based on table gme_batch_step_resources
APPS.GME_BATCH_STEP_RESOURCES_V·↳ CR_RSRC_MST·↳ FND_DATE·↳ FND_TIMEZONES·Explore GME module →
-
GMD Operation Resources View
APPS.PMITS_OPERATION_RESOURCES_V·↳ DUAL·Explore PMI module →
-
GMD Operation Resources View
APPS.PMITS_OPERATION_RESOURCES_V·↳ DUAL·Explore PMI module →
-
View: GMD_MBR_RECIPE_RSRC_V1 12.1.1
This view is used to retrieve Resource Requirements Information for Master Batch Record XML generation.
APPS.GMD_MBR_RECIPE_RSRC_V1·↳ CR_RSRC_MST_B·↳ FM_ROUT_DTL·↳ GMD_OPERATIONS_B·Explore GMD module →
-
Supplementary view based on table gme_batch_step_resources
APPS.GME_BATCH_STEP_RESOURCES_V·↳ CR_RSRC_MST·↳ FND_DATE·↳ FND_TIMEZONES·Explore GME module →
-
Batch Operation Details
APPS.PMIFV_BATCH_OPRN_DETAIL_V·↳ CR_RSRC_MST·↳ FM_FORM_MST_B·↳ GME_BATCH_HEADER·Explore PMI module →
-
View: FM_OPRN_DTL_VW1 12.1.1
Operation detail view
APPS.FM_OPRN_DTL_VW1·↳ GMD_OPERATION_ACTIVITIES·↳ GMD_OPERATION_RESOURCES·Explore GMD module →
-
Batch operation (step) details. This table contains information for each resource within an activity of batch step.
-
View: GMD_MBR_RECIPE_RSRC_V1 12.2.2
This view is used to retrieve Resource Requirements Information for Master Batch Record XML generation.
APPS.GMD_MBR_RECIPE_RSRC_V1·↳ CR_RSRC_MST_B·↳ FM_ROUT_DTL·↳ GMD_OPERATIONS_B·Explore GMD module →
-
Batch operation (step) details. This table contains information for each resource within an activity of batch step.
-
Operation Resource details
-
Batch Operation Details
APPS.PMIFV_BATCH_OPRN_DETAIL_V·↳ CR_RSRC_MST·↳ FM_FORM_MST_B·↳ GME_BATCH_HEADER·Explore PMI module →
-
View: FM_OPRN_DTL_VW1 12.2.2
Operation detail view
APPS.FM_OPRN_DTL_VW1·↳ GMD_OPERATION_ACTIVITIES·↳ GMD_OPERATION_RESOURCES·Explore GMD module →
-
Batch operation details.
-
Operation Resource details
-
Batch operation details.
-
VIEW: GMD.FM_OPRN_DTL_BAK# 12.2.2
-
View: PMI_EDW_BTCH_RSRC_F_IV 12.1.1
Not implemented in this database·Explore PMI module →
-
View: PMI_EDW_BTCH_RSRC_F_IV 12.2.2
Not implemented in this database·Explore PMI module →
-
VIEW: GME.PM_OPRN_DTL# 12.2.2
-
VIEW: GMD.FM_OPRN_DTL_BAK# 12.2.2
-
TABLE: GMD.FM_OPRN_DTL_BAK 12.1.1
-
VIEW: GME.PM_OPRN_DTL# 12.2.2
-
TABLE: GMD.FM_OPRN_DTL_BAK 12.2.2
-
TABLE: GME.PM_OPRN_DTL 12.1.1
-
TABLE: GME.PM_OPRN_DTL 12.2.2