ENG Views (113)

ENG - Engineering — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`EDWBV_ITEM_ITEMORGPF_LCV`	This view contains Product Family items at the item/organization level.
`EDWBV_ITEM_ITEMORG_LCV`	This view contains items at the item/organization level.
`EDWBV_ITEM_ITEMREV_LCV`	This view contains item revisions.
`EDWBV_ITEM_ITEM_CAT_LCV`	This view includes item category association
`EDWBV_ITEM_ITEM_LCV`	The view holds the item level item information
`EDWBV_ITEM_ITEM_ORG_CAT_LCV`	This view holds item organization level category association
`EDW_BRES_DEPT_CLASS_LCV`	This view holds the resource department class information
`EDW_BRES_DEPT_LCV`	This view holds resource department information
`EDW_BRES_PLANT_LCV`	This view holds resource plant information
`EDW_BRES_RESCAT_LCV`	This view holds resource category information
`EDW_BRES_RESGROUP_LCV`	This view holds resource group information
`EDW_BRES_RESOURCE_LCV`	This view holds resource information
`EDW_BRES_RESTYPE_LCV`	This view holds the resource type information
`EDW_ITEMS_CATEGORY_FKV`	This view holds the item category assignment information
`EDW_ITEMS_ITEM_ORG_FKV`	This view holds item - organization information
`EDW_ITEMS_ITEM_REV_FKV`	This view holds item - revision information
`EDW_ITEM_ITEMORGPF_LCV`	This view holds the product family item information
`EDW_ITEM_ITEMORG_LCV`	This view holds item - organization level information
`EDW_ITEM_ITEMREV_LCV`	This view holds item revision level information
`EDW_ITEM_ITEM_CAT_LCV`	This view holds item level category information
`EDW_ITEM_ITEM_LCV`	This view holds item level item information
`EDW_ITEM_ITEM_ORG_CAT_LCV`	This view holds item organization level category information
`EDW_ITEM_ONETIME_ITEMORG_LCV`	This view holds item organization level onetime item information
`EDW_ITEM_ONETIME_ITEM_LCV`	This view holds item level onetime items' information
`EDW_ITEM_PRDFAM_LCV`	This view holds product family information
`EDW_ITEM_PROD_CATG_LCV`	This view holds product category information
`EDW_ITEM_PROD_GRP_LCV`	This view holds product group information
`EDW_ITEM_PROD_LINE_LCV`	This view holds product line information
`ENGBV_ECO_PRIORITIES`	- Retrofitted
`ENGBV_ECO_REVISED_ITEMS`
`ENGBV_ECO_REVISIONS`	- Retrofitted
`ENGBV_ECO_WORKFLOW_RULES`	- Retrofitted
`ENGBV_ENGINEERING_CHANGE_TYPES`	- Retrofitted
`ENGBV_ENGINEERING_CHNG_ORDERS`
`ENGBV_ENG_CHANGE_APPROVERS`	- Retrofitted
`ENGBV_ENG_CHANGE_REASONS`	- Retrofitted
`ENGBV_ENG_CHNG_APPROVAL_LISTS`	- Retrofitted
`ENGBV_WORKFLOW_PROCESSES`	- Retrofitted
`ENGFV_ECO_PRIORITIES`	- Retrofitted
`ENGFV_ECO_REVISED_ITEMS`
`ENGFV_ECO_REVISIONS`	- Retrofitted
`ENGFV_ECO_WORKFLOW_RULES`	- Retrofitted
`ENGFV_ENGINEERING_CHANGE_TYPES`	- Retrofitted
`ENGFV_ENGINEERING_CHNG_ORDERS`
`ENGFV_ENG_CHANGE_APPROVERS`	- Retrofitted
`ENGFV_ENG_CHANGE_REASONS`	- Retrofitted
`ENGFV_ENG_CHNG_APPROVAL_LISTS`	- Retrofitted
`ENGFV_WORKFLOW_PROCESSES`	- Retrofitted
`ENG_AUTONUM_ALL_ORGS_V`	Autonumbering information for all organizations, not specific organizations
`ENG_AUTONUM_ORGS_V`	Autonumbering information for specific organizations
`ENG_AUTO_NUMBER_ECN_USERS_V`	Autonumbering information for specific users
`ENG_CHANGES_EXT_VL`
`ENG_CHANGES_V`
`ENG_CHANGE_ACTIONS_VL`
`ENG_CHANGE_CLASSIFICATIONS_VL`
`ENG_CHANGE_HDR_ITEM_SUBJECTS_V`
`ENG_CHANGE_LINES_EXT_VL`
`ENG_CHANGE_LINES_VL`
`ENG_CHANGE_LOGS_VL`
`ENG_CHANGE_MGMT_TYPES_VL`
`ENG_CHANGE_OBJECTS_V`
`ENG_CHANGE_OBJECTS_VL`
`ENG_CHANGE_OBJ_RELATIONSHIPS_V`
`ENG_CHANGE_OCV`
`ENG_CHANGE_ORDER_REVISIONS_V`	Engineering change order (ECO) revisions
`ENG_CHANGE_ORDER_TYPES_V`	Engineering change order types - all records
`ENG_CHANGE_ORDER_TYPES_VAL_V`	Engineering change order types - enabled records only
`ENG_CHANGE_ORDER_TYPES_VL`	Engineering change order types - all records
`ENG_CHANGE_POLICIES_V`
`ENG_CHANGE_RELATIONS_V`
`ENG_CHANGE_ROUTES_VL`
`ENG_CHANGE_ROUTE_PEOPLE_V`
`ENG_CHANGE_ROUTE_PEOPLE_VL`
`ENG_CHANGE_ROUTE_STEPS_VL`
`ENG_CHANGE_RULE_ATTRIBUTES_VL`
`ENG_CHANGE_STATUSES_VL`
`ENG_CHANGE_SUBJECTS_V`
`ENG_CHANGE_TASKS_VL`
`ENG_CHANGE_TEMPLATES_VL`
`ENG_CHANGE_TYPE_PROCESSES_V`	Engineering change type processes
`ENG_CHANGE_TYPE_ROUTES_V`
`ENG_COMPONENT_VIEW`	This view joins BOM_INVENTORY_COMPONENTS and ENG_REVISED_COMPONENTS to display all revised components for a revised item
`ENG_CURRENT_SCHEDULED_DATES_V`	Current and historical ECO scheduled implementation dates
`ENG_ECN_APPROVERS_V`	Engineering change order approvers
`ENG_ECO_DEPARTMENTS_VIEW`	All ECO departments in HR_ORGANIZATION_UNITS
`ENG_ECO_SUBMIT_REVS_V`	Resolves all foreign keys in the table ENG_ECO_SUBMIT_REVISIONS
`ENG_ENGINEERING_CHANGES_ALL_V`	All engineering change orders
`ENG_ENGINEERING_CHANGES_ERV`
`ENG_ENGINEERING_CHANGES_V`	Engineering change orders
`ENG_ENGINEERING_CHANGES_VAL_V`	Non-cancelled engineering change orders
`ENG_ENG_CHANGES_API_V`	View used in ECO workflow
`ENG_ENG_CHANGES_INTERFACE_V`	Mass change orders
`ENG_IMPACTED_BILLS_ERV`
`ENG_REVISED_COMPONENTS_ERV`	Pending, implemented, and cancelled revised components
`ENG_REVISED_COMPONENTS_V`	Pending, implemented, and cancelled revised components
`ENG_REVISED_ITEMS_API_V`	Pending and implemented revised items
`ENG_REVISED_ITEMS_ERV`	Pending and implemented revised items
`ENG_REVISED_ITEMS_INTERFACE_V`	Mass change details
`ENG_REVISED_ITEMS_SCHEDULE_V`	Engineering change order schedules
`ENG_REVISED_ITEMS_V`	Pending and implemented revised items
`ENG_REVISED_OPERATIONS_V`	Pending and implemented revised operations
`ENG_SEARCH_PEOPLE_V`
`ENG_SECURITY_GROUP_MEMBERS_V`
`ENG_SECURITY_PEOPLE_V`
`ENG_SUBJECTS_VL`
`ENG_SUBJECT_ENTITIES_V`
`ENG_WEB_REF_DESIG_V`	Revised reference designators designed for use in Oracle self service web applications
`ENG_WEB_REVISED_COMPS_V`	Revised component on an ECO designed for use in Oracle self service web applications
`ENG_WEB_SCHEDULE_V`	Revised items
`ENG_WEB_SUB_COMPS_V`	Revised substitute components designed for use in Oracle self service web applications
`ENG_WF_PROCESS_V`	Lists of all root proceses for 'ECO_APP' item type
`SAM`	- Retrofitted
`XX`	- Retrofitted