Results for “ctp_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.MTL_EAM_EQUIP_RESOURCES_V is a reporting and integration view in the Oracle E-Business Suite Inventory (INV) module, specifically supporting Enterprise Asset Management (EAM) equipment resource functionality. The view consolidates equipment resource definitions, their assignment to departments, and their associated serialized instances into a single denormalized result set, allowing callers to retrieve resource-level attributes (such as unit of measure, autocharge behavior, and capacity sharing rules) alongside department ownership information and instance-level serial numbers.
The object is owned by the APPS schema and is marked VALID in the ETRM repository. Its principal role is to provide a stable, queryable interface for EAM and manufacturing scheduling logic that must resolve which resource an equipment instance belongs to, which department owns or shares it, and how capacity and charging are governed. Because the view is exposed in the APPS schema, it is intended for use by concurrent programs, form logic, and external integrations rather than direct base-table access. It is commonly queried in scenarios involving resource utilization reporting, maintenance scheduling, and capacity planning across departments.
Underlying Base Objects
The view is defined over a set of APPS synonyms referencing the following base objects: BOM_DEPARTMENTS, BOM_DEPARTMENT_RESOURCES, BOM_DEPT_RES_INSTANCES, BOM_RESOURCES, BOM_RESOURCE_EQUIPMENTS, and the subordinate view GMP_EAM_EQUIP_RESOURCES_V. The primary SELECT joins these objects on organization, resource, instance, and department identifiers, then forms a UNION with the corresponding rows drawn from GMP_EAM_EQUIP_RESOURCES_V. Joins include BOM_DEPT_RES_INSTANCES to BOM_RESOURCE_EQUIPMENTS on both RESOURCE_ID and INSTANCE_ID, BOM_RESOURCES on ORGANIZATION_ID and RESOURCE_ID, and BOM_DEPARTMENT_RESOURCES via a DECODE that resolves the owning department (using SHARE_FROM_DEPT_ID when present, otherwise DEPARTMENT_ID). BOM_DEPARTMENTS is joined twice — once as the primary department (BD) and once as an outer-joined shared department (BD1, using BD1.DEPARTMENT_ID(+) = BDR.SHARE_FROM_DEPT_ID) — to derive SHARE_FROM_DEPT_CODE and OWNING_DEPARTMENT_CODE.
Key Columns
ROW_ID— row identifier derived from theBOM_DEPARTMENT_RESOURCESrow.ORGANIZATION_ID,INVENTORY_ITEM_ID,SERIAL_NUMBER— identify the equipment item and its serialized instance.RESOURCE_ID,RESOURCE_CODE,DESCRIPTION— the resource definition.INSTANCE_ID— the EAM instance tied to the resource.DEPARTMENT_ID,DEPARTMENT_CODE,SHARE_FROM_DEPT_ID,SHARE_FROM_DEPT_CODE,OWNING_DEPARTMENT_CODE— department ownership and sharing resolution.CAPACITY_UNITS,AVAILABLE_24_HOURS_FLAG,RESOURCE_GROUP_NAME,SHARE_CAPACITY_FLAG,UNIT_OF_MEASURE— capacity and scheduling attributes.AUTOCHARGE_TYPE— indicates how the resource is charged or costed (a value of particular interest to users searching this term).CTP_FLAG— capability-to-promise indicator.SCHEDULE_TO_INSTANCE— flag controlling whether scheduling targets the instance level.
Common Use Cases and Queries
A typical integration query retrieves all equipment resources for an organization together with their charging model and owning department:
SELECT resource_code, serial_number, owning_department_code, unit_of_measure, autocharge_type, ctp_flag
FROM apps.mtl_eam_equip_resources_v
WHERE organization_id = :org_id;
The AUTOCHARGE_TYPE column is frequently used to filter resources by charging behavior, for example to isolate resources set to charge automatically versus manually. Capacity planning reports join CAPACITY_UNITS and AVAILABLE_24_HOURS_FLAG to compute available hours, while scheduling integrations consult CTP_FLAG and SCHEDULE_TO_INSTANCE. Because the view includes an outer join to the shared department, OWNING_DEPARTMENT_CODE should be used rather than DEPARTMENT_CODE when the true owning department is required.
-
View for EAM equipment resources
APPS.MTL_EAM_EQUIP_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_DEPT_RES_INSTANCES·Explore INV module →
-
View for EAM equipment resources
APPS.MTL_EAM_EQUIP_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_DEPT_RES_INSTANCES·Explore INV module →
-
View: WIP_DEPT_RESOURCES_V 12.1.1
Resources owned by a department
APPS.WIP_DEPT_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
View: WIP_DEPT_RESOURCES_V 12.2.2
Resources owned by a department
APPS.WIP_DEPT_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
Equipment resource instances
APPS.WIP_RES_INST_EQUIPMENTS_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
APPS.GMP_EAM_EQUIP_RESOURCES_V·↳ CR_RSRC_DTL·↳ CR_RSRC_MST·↳ GMP_RESOURCE_EQUIPMENTS·Explore GMP module →
-
Equipment to resource mapping view
APPS.GMP_EAM_EQUIP_RESOURCES_V·↳ CR_RSRC_DTL·↳ CR_RSRC_MST·↳ GMP_RESOURCE_EQUIPMENTS·Explore GMP module →
-
Resources associated with departments
APPS.BOM_DEPARTMENT_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_RESOURCES·Explore BOM module →
-
Archive of deleted routings
-
Routings
-
Routings
-
Table: BOM_RTGHEADER_TEMP 12.2.2
Used in XML Routing Header import process
-
Equipment resource instances
APPS.WIP_RES_INST_EQUIPMENTS_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
This table stores the different routings available for a bill of material.
-
Table: BOM_RTGHEADER_TEMP 12.1.1
Used in XML Routing Header import process
-
View: ENG_REVISED_ITEMS_ERV 12.1.1
Pending and implemented revised items
APPS.ENG_REVISED_ITEMS_ERV·↳ BOM_BILL_OF_MATERIALS·↳ BOM_OPERATIONAL_ROUTINGS·↳ ENG_REVISED_ITEMS·Explore ENG module →
-
The staging table used by the collection program to validate and process data for table MSC_ROUTINGS.
-
APPS.BOM_OPERATIONAL_ROUTINGS_ERV·↳ BOM_OPERATIONAL_ROUTINGS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_ITEM_FLEXFIELDS·Explore BOM module →
-
View: ENG_REVISED_ITEMS_V 12.2.2
Pending and implemented revised items
APPS.ENG_REVISED_ITEMS_V·↳ BOM_BILL_OF_MATERIALS·↳ BOM_OPERATIONAL_ROUTINGS·↳ ENG_REVISED_ITEMS·Explore ENG module →
-
View: ENG_REVISED_ITEMS_V 12.1.1
Pending and implemented revised items
APPS.ENG_REVISED_ITEMS_V·↳ BOM_BILL_OF_MATERIALS·↳ BOM_OPERATIONAL_ROUTINGS·↳ ENG_REVISED_ITEMS·Explore ENG module →
-
Resources associated with departments
-
This table stores the different routings available for a bill of material.
-
The staging table used by the collection program to validate and process data for table MSC_DEPARTMENT_RESOURCES.
-
Employee resource instances
APPS.WIP_RES_INST_EMPLOYEES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
Employee resource instances
APPS.WIP_RES_INST_EMPLOYEES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES_V·↳ BOM_RESOURCES·Explore WIP module →
-
The staging table used by the collection program to validate and process data for table MSC_DEPARTMENT_RESOURCES.
-
This table stores the resources available for planning.
-
Pending and implemented revised items
-
Resources associated with departments
APPS.BOM_DEPARTMENT_RESOURCES_V·↳ BOM_DEPARTMENTS·↳ BOM_DEPARTMENT_RESOURCES·↳ BOM_RESOURCES·Explore BOM module →
-
Routing interface data
-
APPS.BOM_OPERATIONAL_ROUTINGS_ERV·↳ BOM_OPERATIONAL_ROUTINGS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_ITEM_FLEXFIELDS·Explore BOM module →
-
Resources associated with departments
-
Archive of deleted routings
-
View: ENG_REVISED_ITEMS_ERV 12.2.2
Pending and implemented revised items
APPS.ENG_REVISED_ITEMS_ERV·↳ BOM_BILL_OF_MATERIALS·↳ BOM_OPERATIONAL_ROUTINGS·↳ ENG_REVISED_ITEMS·Explore ENG module →
-
Routings
APPS.BOM_OPERATIONAL_ROUTINGS_V·↳ BOM_OPERATIONAL_ROUTINGS·↳ MTL_ITEM_FLEXFIELDS·↳ MTL_SECONDARY_INVENTORIES·Explore BOM module →
-
Routings
APPS.BOM_OPERATIONAL_ROUTINGS_V·↳ BOM_OPERATIONAL_ROUTINGS·↳ MTL_ITEM_FLEXFIELDS·↳ MTL_SECONDARY_INVENTORIES·Explore BOM module →
-
This table stores the resources available for planning.
-
Routing interface data
-
The staging table used by the collection program to validate and process data for table MSC_ROUTINGS.
-
Pending and implemented revised items
-
VIEW: MSC.MSC_ROUTINGS# 12.2.2
-
VIEW: MSC.MSC_ST_ROUTINGS# 12.2.2
-
VIEW: MSC.MSC_ROUTINGS# 12.2.2