BOM Views (480)
BOM - Bills of Material — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| View | Description |
|---|---|
BOMBV_ALTERNATE_BOM_CODES |
This shows codes(designators) which can be used to define alternate |
BOMBV_BILL_OF_MATERIALS |
This shows the product assembly structure |
BOMBV_BOM_COMPONENTS |
This shows individual item components in a engineering or manufacturing |
BOMBV_BOM_REFERE_DESIGNATORS |
- Retrofitted |
BOMBV_BOM_REVISIONS |
- Retrofitted |
BOMBV_ECO_REVISED_COMPONENTS |
- Retrofitted |
BOMBV_ENGINEERING_BOMS |
- Retrofitted |
BOMBV_FLOW_ROUTINGS |
- Retrofitted |
BOMBV_FLOW_ROUTING_EVENTS |
- Retrofitted |
BOMBV_FLOW_ROUTING_PROCESSES |
- Retrofitted |
BOMBV_FLOW_RTG_LINE_OPERATIONS |
- Retrofitted |
BOMBV_INTERNAL_MFG_RESOURCES |
- Retrofitted |
BOMBV_MANUFACTURING_BOMS |
- Retrofitted |
BOMBV_MANUFACTURING_LINES |
- Retrofitted |
BOMBV_MFG_DEPARTMENTS |
- Retrofitted |
BOMBV_MFG_DEPARTMENT_CLASSES |
- Retrofitted |
BOMBV_MFG_DEPARTMENT_RESOURCES |
- Retrofitted |
BOMBV_MFG_OPERATIONS |
- Retrofitted |
BOMBV_MFG_RESOURCES |
- Retrofitted |
BOMBV_MFG_RESOURCE_SHIFTS |
- Retrofitted |
BOMBV_MFG_SHIFT_MODIFICATIONS |
- Retrofitted |
BOMBV_MFG_STANDARD_OPERATIONS |
- Retrofitted |
BOMBV_OPERATION_NETWORKS |
- Retrofitted |
BOMBV_OUTSIDE_OPRATN_RESOURCES |
- Retrofitted |
BOMBV_ROUTINGS |
- Retrofitted |
BOMBV_ROUTING_REVISIONS |
- Retrofitted |
BOMBV_RTG_OPERATION_RESOURCES |
- Retrofitted |
BOMBV_STANDARD_RTG_OPERATIONS |
- Retrofitted |
BOMBV_STD_FLOW_RTG_OPERATIONS |
- Retrofitted |
BOMBV_STD_OPRATN_RESOURCES |
- Retrofitted |
BOMBV_SUBSTITUTE_BOM_COMPS |
- Retrofitted |
BOMBV_WORK_ORDER_ROUTINGS |
- Retrofitted |
BOMBV_WORK_ORDER_RTG_OPRATNS |
- Retrofitted |
BOMFV_ALTERNATE_BOM_CODES |
- Retrofitted |
BOMFV_BILL_OF_MATERIALS |
- Retrofitted |
BOMFV_BOM_COMPONENTS |
- Retrofitted |
BOMFV_BOM_REFERE_DESIGNATORS |
- Retrofitted |
BOMFV_BOM_REVISIONS |
- Retrofitted |
BOMFV_ECO_REVISED_COMPONENTS |
- Retrofitted |
BOMFV_ENGINEERING_BOMS |
- Retrofitted |
BOMFV_FLOW_ROUTINGS |
- Retrofitted |
BOMFV_FLOW_ROUTING_EVENTS |
- Retrofitted |
BOMFV_FLOW_ROUTING_PROCESSES |
- Retrofitted |
BOMFV_FLOW_RTG_LINE_OPERATIONS |
- Retrofitted |
BOMFV_INTERNAL_MFG_RESOURCES |
- Retrofitted |
BOMFV_MANUFACTURING_BOMS |
- Retrofitted |
BOMFV_MANUFACTURING_LINES |
- Retrofitted |
BOMFV_MFG_DEPARTMENTS |
- Retrofitted |
BOMFV_MFG_DEPARTMENT_CLASSES |
- Retrofitted |
BOMFV_MFG_DEPARTMENT_RESOURCES |
- Retrofitted |
BOMFV_MFG_OPERATIONS |
- Retrofitted |
BOMFV_MFG_RESOURCES |
- Retrofitted |
BOMFV_MFG_RESOURCE_SHIFTS |
- Retrofitted |
BOMFV_MFG_SHIFT_MODIFICATIONS |
- Retrofitted |
BOMFV_MFG_STANDARD_OPERATIONS |
- Retrofitted |
BOMFV_OPERATION_NETWORKS |
- Retrofitted |
BOMFV_OUTSIDE_OPRATN_RESOURCES |
- Retrofitted |
BOMFV_ROUTINGS |
- Retrofitted |
BOMFV_ROUTING_REVISIONS |
- Retrofitted |
BOMFV_RTG_OPERATION_RESOURCES |
- Retrofitted |
BOMFV_STANDARD_RTG_OPERATIONS |
- Retrofitted |
BOMFV_STD_FLOW_RTG_OPERATIONS |
- Retrofitted |
BOMFV_STD_OPRATN_RESOURCES |
- Retrofitted |
BOMFV_SUBSTITUTE_BOM_COMPS |
- Retrofitted |
BOMFV_WORK_ORDER_ROUTINGS |
- Retrofitted |
BOMFV_WORK_ORDER_RTG_OPRATNS |
- Retrofitted |
BOM_ALTERNATE_DESIGNATORS_VL |
This is a view over alternate designator code base table and translation table |
BOM_ALT_DESIGNATORS_ALL_V |
View for bill/routing alternates list of values - all records |
BOM_ALT_DESIGNATORS_VAL_V |
View for bill/routing alternates list of values - only enabled records |
BOM_ATTRS_V |
Displays the BOM attributes |
BOM_BILL_ALTERNATES_V |
BOM_BILL_ALTERNATES_V resolves all foreign key references for the table BOM_BILL_ALTERNATES |
BOM_BILL_NO_HOLD_REVISIONS_V |
Item revisions not on hold |
BOM_BILL_OF_MATERIALS |
BOM_BILL_OF_MATERIALS stores information of BOM_STRUCTURES_B which further stores information about manufacturing and engineering bills of m |
BOM_BILL_OF_MATERIALS_ERV |
Bill Of Materials view for ERES |
BOM_BILL_OF_MATERIALS_V |
Bills of material |
BOM_BILL_OF_MTLS_QF_V |
View for bill of materials list of values |
BOM_BILL_RELEASED_REVISIONS_V |
Engineering change order released item revisions |
BOM_BILL_REVISIONS_VL |
This is a view over Bom revisions base table and bom revisions translations |
BOM_CAD_COMPONENT_ATTR_V |
Bom Cad Components Attributes and Values |
BOM_CALENDARS_VIEW |
View of BOM_CALENDARS table |
BOM_CALENDAR_MONTHS_VIEW |
Each month of the manufacturing calendar |
BOM_CALENDAR_WEEKS_VIEW |
Workdays and non-workdays of the month - used in Calendar window |
BOM_COMPONENTS_EXT_VL |
BOM components extensible attributes view |
BOM_COMPONENTS_OCV |
BOM_COMPONENTS_OCV stores information to display bom structure type. |
BOM_COMPONENT_ALL_OPERATIONS_V |
View of all operation for components - all records |
BOM_COMPONENT_OPERATIONS_V |
View of all component operation |
BOM_CONSOLIDATE_EXPLOSION_VIEW |
Consolidated Bill of Material structure for report |
BOM_COPY_EXPLOSIONS_V |
View for Multi level copy structure |
BOM_CTO_SRC_ORGS |
BOM_CTO_SRC_ORGS |
BOM_DELETE_ENTITIES_V |
Deleted entities in BOM and INV |
BOM_DELETE_ERRORS_V |
Errors occurring when deleting entities |
BOM_DELETE_SUB_ENTITIES_V |
Component and operations to be deleted |
BOM_DEPARTMENTS_ALL_V |
View for department list of values - all records |
BOM_DEPARTMENTS_V |
Departments |
BOM_DEPARTMENTS_VAL_V |
View for department list of values - only enabled records |
BOM_DEPARTMENT_RESOURCES_V |
Resources associated with departments |
BOM_DEPENDENT_DESC_ELEMENTS_V |
Descriptive elements assigned to model/option bills |
BOM_DEPT_RES_INSTANCES_EMP_V |
Resources Instance associated with departments |
BOM_DEPT_RES_INSTANCES_EQP_V |
Resources Instance associated with departments |
BOM_EAM_DEPT_APPROVERS_VL |
This view shows the association between the departments and resposibility which receive notifications when a work request is created. |
BOM_EXPLOSIONS_ALL_V |
View over BOM_EXPLOSIONS_ALL Table |
BOM_EXPLOSION_VIEW |
Indented bill of material for report |
BOM_EXPL_INQUIRY_VIEW |
Indented bill of material for window |
BOM_IMPLOSIONS_V |
View for displaying BOM implosions |
BOM_IMPLOSION_VIEW |
Used for inquiry report |
BOM_IMPL_INQUIRY_V |
Item usage information |
BOM_IMPL_INQUIRY_VIEW |
Used for inquiry window |
BOM_INVENTORY_COMPONENTS |
BOM_INVENTORY_COMPONENTS stores information of BOM_COMPONENTS_B which further stores information about bills of material components and stor |
BOM_INVENTORY_COMPONENTS_ERV |
|
BOM_INVENTORY_COMPONENTS_V |
Bill of material components |
BOM_INV_COMPS_INTERFACE_ERV |
Mass change components |
BOM_INV_COMPS_INTERFACE_V |
Mass change components |
BOM_ITEM_CURRENT_REV_VIEW |
Item current revisions |
BOM_ITEM_REVISIONS_VIEW |
View of item revisions with start and high dates |
BOM_LINES_VIEW |
Order lines - used by delete constraints |
BOM_LINE_DETAILS_VIEW |
Order line details -- used by delete constraints |
BOM_MIXED_MODEL_MAP_CELLS_V |
View for reformatting data in BOM_MIXED_MODEL_MAP_CELLS for display |
BOM_MIXED_MODEL_MAP_PROC_V |
Contains process, line operation, and summary information for a mixed model map |
BOM_MIXED_MODEL_MAP_RES_V |
|
BOM_ODI_WS_COMPONENTS_V |
|
BOM_ODI_WS_CTX_PATHS_V |
|
BOM_ODI_WS_VS_EXCL_V |
|
BOM_OPERATIONAL_ROUTINGS_ERV |
|
BOM_OPERATIONAL_ROUTINGS_V |
Routings |
BOM_OPERATION_NETWORKS_V |
Operation networks view |
BOM_OPERATION_RESOURCES_V |
Operation resources |
BOM_OPERATION_SEQUENCES_V |
Operations |
BOM_OPERATION_SKILLS_V |
BOM Operations Skills View |
BOM_OP_RESOURCES_VIEW |
Operation resources view |
BOM_ORG_CAL_DATES_VIEW |
Calendar dates by organization |
BOM_ORG_CAL_PERIODS_VIEW |
View for period start dates |
BOM_ORG_CAL_WEEKS_VIEW |
Week start dates |
BOM_ORG_SHIFT_DATES_VIEW |
Shift dates for an organization's calendar - used in Calendar window |
BOM_PICKING_LINES_VIEW |
Order picking lines - used by delete constraints |
BOM_PLM_EXPLOSION_TEMP |
|
BOM_PRODUCTFAMILY_MEM_V |
View on BOM_INVENTORY_COMPONENTS and MTL_SYSTEMS_ITEMS, used by the product family functionality in R11 |
BOM_REFERENCE_DESIGNATORS_V |
Component reference designators |
BOM_REF_DESIGNATORS_VIEW |
Both implemented and unimplemented reference designators |
BOM_RESOURCES_ALL_V |
View for resource list of values - all records |
BOM_RESOURCES_V |
Resources, overheads, material cost codes, and material overheads |
BOM_RESOURCES_VAL_V |
View for resource list of values - only enabled records |
BOM_RESOURCE_CHANGES_V |
Resource capacity modifications |
BOM_RESOURCE_DOWNCODES_V |
View based on Table BOM_RESOURCE_DOWNCODES for Defining Down Codes |
BOM_RESOURCE_SHIFTS_V |
Resource shift information |
BOM_RES_INSTANCE_CHANGES_EMP_V |
Resource instance modifications |
BOM_RES_INSTANCE_CHANGES_EQP_V |
Resource instance modifications |
BOM_ROUTING_ALTERNATES_V |
BOM_ROUTING_ALTERNATES_V resolves all foreign key references for the table BOM_ROUTING_ALTERNATES |
BOM_ROUTING_REVISIONS_VIEW |
View of routing revisions with start and high dates |
BOM_RTG_CURRENT_REV_VIEW |
Routing current revisions |
BOM_SETUP_TYPES_V |
BOM Setup types |
BOM_SHIFT_MONTHS_VIEW |
Calendar shift months - used in calendar window |
BOM_SHIFT_WEEKS_VIEW |
Shift calendar dates - used in calendar window |
BOM_STANDARD_OPERATIONS_ALL_V |
Standard operations - all records |
BOM_STANDARD_OPERATIONS_V |
Standard operations |
BOM_STANDARD_OPERATIONS_VAL_V |
Valid standard operations |
BOM_STD_OP_BONUS_CODES_V |
Displays the bonus codes of a standard operation |
BOM_STD_OP_RESOURCES_V |
Standard operation resources |
BOM_STD_OP_RESP_EXCL_V |
BOM_STD_OP_RESP_EXCL_V stores information about Standard Operation responsibility exclusions. View based on BOM_STD_OP_RESP_EXCL.A supplemen |
BOM_STD_OP_SCRAP_CODES_V |
Displays information about scrap codes for a standard operation |
BOM_STD_SUB_OP_RESOURCES_V |
This view is for the alternate resources on standard operations |
BOM_STP_STD_OP_RESOURCES_V |
Standard operation resources |
BOM_STRUCTURES_EXT_VL |
Extensible attribute view for BOM structures |
BOM_STRUCTURES_OCV |
BOM_STRUCTURES_OCV stores information to display bom structure type. |
BOM_STRUCTURE_REVISIONS_VL |
This is a view over Bom revisions base table and bom revisions translations |
BOM_STRUCTURE_SYNC_V |
This View is used for Structure Sync operations with external systems. Currently this is being used for Complex Product Sync with Siebel for |
BOM_STRUCTURE_TYPES_VL |
This is a view over Structure type base table and translation table |
BOM_STRUCT_ATTR_GRP_ASSOCS_V |
Displays BOM structure attribute group associations |
BOM_SUBSTITUTE_COMPONENTS_ERV |
Substitute components |
BOM_SUBSTITUTE_COMPONENTS_V |
Substitute components |
BOM_SUB_COMPONENTS_VIEW |
Both implemented and unimplemented substitute components |
BOM_SUB_COMPS_QF_V |
View for substitute components list of values |
BOM_SUB_OPERATION_RESOURCES_V |
View for substitue resources |
CSTBV_AVERAGE_ITEM_COSTS |
- Retrofitted |
CSTBV_COST_ELEMENTS |
- Retrofitted |
CSTBV_COST_GROUPS |
- Retrofitted |
CSTBV_COST_GROUP_ASSIGNMENTS |
|
CSTBV_COST_TYPES |
- Retrofitted |
CSTBV_ITEM_COST_TXN_HISTORY |
- Retrofitted |
CSTBV_ITEM_STD_COST_UPDATES |
- Retrofitted |
CSTBV_ITEM_STD_COST_UPDT_HIST |
- Retrofitted |
CSTBV_ITEM_STD_CST_UPDATE_ADJ |
- Retrofitted |
CSTBV_ITEM_UNIT_COST_DETAILS |
- Retrofitted |
CSTBV_ITM_CST_GRP_UNT_CST_DTL |
- Retrofitted |
CSTBV_ITM_STD_CST_UPD_ELM_HST |
- Retrofitted |
CSTBV_LE_COST_TYPES |
|
CSTBV_MANUFACTURING_ACTIVITIES |
- Retrofitted |
CSTBV_MANUFACTURING_GL_BATCH |
- Retrofitted |
CSTBV_MATL_COST_SUB_ELEMENT |
- Retrofitted |
CSTBV_MATL_OVHD_CST_SUB_ELMNT |
- Retrofitted |
CSTBV_MATL_TXN_DISTRIBUTIONS |
- Retrofitted |
CSTBV_MFG_ACCTG_PERIOD |
- Retrofitted |
CSTBV_MFG_ACTIVITY_COSTS |
- Retrofitted |
CSTBV_MFG_DEPARTMENT_OVERHEADS |
- Retrofitted |
CSTBV_MFG_RESOURCE_COSTS |
- Retrofitted |
CSTBV_MFG_RESOURCE_OVERHEADS |
- Retrofitted |
CSTBV_MFG_TXN_DISTRIBUTIONS |
- Retrofitted |
CSTBV_PAC_ITEM_COSTS |
This shows the item cost and quantity in a period and cost group. |
CSTBV_PAC_ITEM_COST_DETAILS |
This shows the details of the cost of an item in a period and cost group. The costs are stored by element and level. |
CSTBV_PAC_PERIODS |
Information about periodic costing open and closed periods for each legal entity and cost group combination |
CSTBV_PAC_PERIOD_BALANCES |
CSTBV_PAC_PERIOD_BALANCES stores the WIP balances for all entities withina cost group by period. |
CSTBV_PAC_QUANTITY_LAYERS |
This shows the layer quantity of an item by period |
CSTBV_PERIOD_CLOSE_DTL_BAL |
- Retrofitted |
CSTBV_PERIOD_CLOSE_SUMM_BAL |
- Retrofitted |
CSTBV_PRODUCT_LINE_ACCOUNT |
- Retrofitted |
CSTBV_RCV_ACQ_COSTS |
|
CSTBV_RCV_ACQ_COST_DETAILS |
|
CSTBV_RTNG_OVHD_CST_SUB_ELMNT |
- Retrofitted |
CSTBV_STANDARD_ITEM_COST |
- Retrofitted |
CSTFV_AVERAGE_ITEM_COSTS |
- Retrofitted |
CSTFV_COST_ELEMENTS |
- Retrofitted |
CSTFV_COST_GROUPS |
- Retrofitted |
CSTFV_COST_GROUP_ASSIGNMENTS |
|
CSTFV_COST_TYPES |
- Retrofitted |
CSTFV_ITEM_STD_COST_UPDATES |
- Retrofitted |
CSTFV_ITEM_STD_COST_UPDT_HIST |
- Retrofitted |
CSTFV_ITEM_STD_CST_UPDATE_ADJ |
- Retrofitted |
CSTFV_ITEM_UNIT_COST_DETAILS |
- Retrofitted |
CSTFV_ITM_CST_GRP_UNT_CST_DTL |
- Retrofitted |
CSTFV_ITM_STD_CST_UPD_ELM_HST |
- Retrofitted |
CSTFV_LE_COST_TYPES |
|
CSTFV_MANUFACTURING_ACTIVITIES |
- Retrofitted |
CSTFV_MANUFACTURING_GL_BATCH |
- Retrofitted |
CSTFV_MATL_COST_SUB_ELEMENT |
- Retrofitted |
CSTFV_MATL_OVHD_CST_SUB_ELMNT |
- Retrofitted |
CSTFV_MATL_TXN_DISTRIBUTIONS |
- Retrofitted |
CSTFV_MFG_ACCTG_PERIOD |
- Retrofitted |
CSTFV_MFG_ACTIVITY_COSTS |
- Retrofitted |
CSTFV_MFG_DEPARTMENT_OVERHEADS |
- Retrofitted |
CSTFV_MFG_RESOURCE_COSTS |
- Retrofitted |
CSTFV_MFG_RESOURCE_OVERHEADS |
- Retrofitted |
CSTFV_MFG_TXN_DISTRIBUTIONS |
- Retrofitted |
CSTFV_PAC_ITEM_COSTS |
Stores the item cost and quantity in a period and cost group. |
CSTFV_PAC_ITEM_COST_DETAILS |
Stores the cost details of an item in a period and cost group. |
CSTFV_PAC_PERIODS |
Information about open and closed periods |
CSTFV_PAC_PERIOD_BALANCES |
CSTFV_PAC_PERIOD_BALANCES stores the WIP balances for all entities withina cost group by period. |
CSTFV_PAC_QUANTITY_LAYERS |
Stores the layer quantity of an item by period |
CSTFV_PERIOD_CLOSE_DTL_BAL |
- Retrofitted |
CSTFV_PERIOD_CLOSE_SUMM_BAL |
- Retrofitted |
CSTFV_PRODUCT_LINE_ACCOUNT |
- Retrofitted |
CSTFV_RCV_ACQ_COSTS |
|
CSTFV_RCV_ACQ_COST_DETAILS |
|
CSTFV_RTNG_OVHD_CST_SUB_ELMNT |
- Retrofitted |
CSTFV_STANDARD_ITEM_COST |
- Retrofitted |
CST_ACCOUNTING_EVENT_TYPES_V |
|
CST_ACCT_INFO_V |
Accounting Information for an Inventory Organization |
CST_ACTIVITIES_V |
Activities : SINGLE-ORG view |
CST_ACTIVITIES_VAL_V |
Activities that are not disabled : SINGLE-ORG view |
CST_ACTIVITY_COSTS_V |
Activity cost by cost type : SINGLE-ORG view |
CST_ACTIVITY_COST_VIEW |
Item cost by activity : SINGLE-ORG view |
CST_ACTIVITY_DEPT_COST_VIEW |
Item cost by activity and department : SINGLE-ORG view |
CST_ACTIVITY_FLEX_COST_VIEW |
Item cost by activity flex : SINGLE-ORG view |
CST_ACTIVITY_OP_COST_VIEW |
Item cost by activity and operation : SINGLE-ORG view |
CST_AEL_GL_WIP_V |
|
CST_AEL_SL_WIP_V |
|
CST_AP_VARIANCE_V |
|
CST_AVG_DIST_ACCTS_V |
Default general ledger accounts by cost group |
CST_AVG_ELEM_COSTS_V |
Used by average cost update form |
CST_BIS_MARGIN_ANALYSIS_V |
|
CST_CAT_ELE_EXP_ASSOCS_V |
View table used for "Category Associations" form. |
CST_CG_ITEM_COSTS_VIEW |
This level, previous level and total elemental costs in an average costing organization. |
CST_CG_WIP_ACCT_CLASSES_V |
Accounting classes valid for cost groups |
CST_CIMP_GROUP_ID |
|
CST_CODE_ACTIVITY_COST_VIEW |
Item cost by subelement and activity : SINGLE-ORG view |
CST_CODE_COST_VIEW |
Item cost by subelement : SINGLE-ORG view |
CST_CODE_DEPARTMENT_COST_VIEW |
Item cost by subelement and department : SINGLE-ORG view |
CST_CODE_FLEX_COST_VIEW |
Item cost by subelement flex : SINGLE-ORG view |
CST_CODE_OPERATION_COST_VIEW |
Item cost by operation : SINGLE-ORG view |
CST_COST_GROUPS_V |
This view is based on CST_COST_GROUPS table |
CST_COST_HISTORY_V |
Elemental item cost and adjustment quantity in a standard cost update : SINGLE-ORG view |
CST_COST_TYPES_ALL_V |
All Cost types : SINGLE-ORG view |
CST_COST_TYPES_V |
Resolves all foreign key references for the table CST_COST_TYPES |
CST_COST_TYPES_VAL_V |
Cost types that are not disabled : SINGLE-ORG view |
CST_COST_UPDATES_V |
Cost update information : SINGLE-ORG view |
CST_CQL_CIC_ITEM_COSTS_V |
|
CST_DEFAULT_COST_VIEW |
Default item cost : SINGLE-ORG view |
CST_DEFAULT_DETAIL_COST_VIEW |
Detailed item default cost : SINGLE-ORG view |
CST_DEPARTMENT_OVERHEADS_V |
Departmental overheads : SINGLE-ORG view |
CST_DEPOVH_COST_TYPES_V |
Departmental overheads for cost type : SINGLE-ORG view |
CST_DETAIL_COSTS_FOR_GL_VIEW |
Item cost details used by General Ledger : SINGLE-ORG view |
CST_DETAIL_COST_VIEW |
Detail cost for reports : SINGLE-ORG view |
CST_DISTRIBUTION_LITE_V |
Distributions view for WIP jobs that joins to less tables than CST_DISTRIBUTION_V and has less columns. |
CST_DISTRIBUTION_V |
Transaction details and accounting distributions for a job or schedule in an accounting period : SINGLE-ORG view |
CST_DISTRIBUTION_VIEW |
Summary of transaction value for Work In Process : SINGLE-ORG view |
CST_EAM_ACTIVITY_ESTIMATES_V |
View used to get estimated activity cost |
CST_EAM_ASSET_BY_DEPT_EST_V |
Asset Estimated Cost by Maintenance Department Type |
CST_EAM_ASSET_BY_DEPT_V |
Asset Cost by Maintenance Department Type |
CST_EAM_ASSET_BY_DEPT_VAR_V |
Asset Variance Cost by Maintenance Department Type |
CST_EAM_ASSET_BY_PERIODS_EST_V |
Asset Estimated Cost by Period |
CST_EAM_ASSET_BY_PERIODS_V |
Asset Actual Cost by Period |
CST_EAM_ASSET_BY_PERIODS_VAR_V |
Asset Variance Cost by Period |
CST_EAM_ROLLUP_BYPERIODS_EST_V |
Asset Rollup Estimated Cost by Period |
CST_EAM_ROLLUP_BYPERIODS_VAR_V |
Asset Rollup Variance Cost by Period |
CST_EAM_ROLLUP_BY_DEPT_EST_V |
Asset Rollup Estimated Cost by Maintenance Department Type |
CST_EAM_ROLLUP_BY_DEPT_V |
Asset Rollup Actual Cost by Maintenance Department Type |
CST_EAM_ROLLUP_BY_DEPT_VAR_V |
Asset Rollup Variance Cost by Maintenance Department Type |
CST_EAM_ROLLUP_BY_PERIODS_V |
Asset Rollup Actual Cost by Period |
CST_EDW_BACKLOG_V |
|
CST_EDW_COGS_V |
|
CST_ELEMENT_ACTIVITY_COST_VIEW |
Item cost by element and activity : SINGLE-ORG view |
CST_ELEMENT_CODE_COST_VIEW |
Item cost by element and subelement : SINGLE-ORG view |
CST_ELEMENT_COST_VIEW |
Item cost by element : SINGLE-ORG view |
CST_ELEMENT_DEPT_COST_VIEW |
Item cost by element and department : SINGLE-ORG view |
CST_ELEMENT_OPYLD_COST_VIEW |
|
CST_ELEMENT_OP_COST_VIEW |
Item cost by element and operation : SINGLE-ORG view |
CST_GL_TRANSLATION_VIEW |
Currency exchange rate for reports : SINGLE-ORG view |
CST_INTRANSIT_VALUE_VIEW |
Intransit value information : SINGLE-ORG view |
CST_INV_DISTRIBUTION_V |
Material transaction distribution information : SINGLE-ORG view |
CST_INV_LAYER_COST_DETAILS_V |
|
CST_ITEM_COSTS_FOR_GL_VIEW |
Item costs depending on costing method : SINGLE-ORG view |
CST_ITEM_COSTS_VIEW |
Total item cost : SINGLE-ORG view |
CST_ITEM_COST_DETAILS_V |
Item cost details for an organization : SINGLE-ORG view |
CST_ITEM_COST_TYPE_V |
Item cost information for a cost type in an organization : SINGLE-ORG view |
CST_ITEM_OVERHEAD_DEFAULTS_V |
Resolves all foreign key references for the table CST_ITEM_OVERHEAD_DEFAULTS |
CST_LAYER_ACTUAL_COSTS_V |
|
CST_LAYER_ACTUAL_COST_DTLS_V |
|
CST_LAYER_COST_DETAILS_V |
Costs by layer, level and cost element |
CST_LC_ADJ_INTERFACE_V |
View on the landed cost adjustment transactions' interface table. Selects information related to the landed cost adjustment transaction alon |
CST_LE_COST_TYPES_V |
|
CST_MATERIAL_OVHD_RULES_V |
|
CST_MGD_LIFO_ITEM_COSTS_V |
View on which the Periodic Costing Item Inquiry form is based |
CST_MGD_LIFO_PERIODS_V |
View to retrieve period information from pac period table restricted by mfg_lookups.lookup_type = CST_PAC_PERIOD_STATUS mfg_lookups.lookup |
CST_MTL_RCV_TXN_V |
|
CST_OPERATION_LEVEL_COST_VIEW |
Item cost by level, element and operation sequence number : SINGLE-ORG view |
CST_OPI_MMT_MTA_V |
This view is used by Inventory Intellegence team for calculating transfer cost for FOB. |
CST_ORGANIZATION_DEFINITIONS |
Inventory organizations |
CST_PAC_AEL_GL_INV_V |
|
CST_PAC_AEL_GL_RCV_V |
|
CST_PAC_AEL_GL_WIP_V |
|
CST_PAC_AEL_SL_INV_V |
|
CST_PAC_AEL_SL_RCV_V |
|
CST_PAC_AEL_SL_WIP_V |
|
CST_PAC_AE_LINES_V |
|
CST_PAC_GL_TRANSLATION_VIEW |
|
CST_PAC_ITEM_COSTS_V |
Summarizes the cost elemental values in CST_PAC_ITEM_COST_DETAILS |
CST_PAC_LEGAL_ENTITIES_V |
Shows denormalized legal entity information for legal entities belonging to Periodic |
CST_PAC_PERIODS_V |
Stores information about open and closed periods |
CST_PAC_PROCESS_PHASES_V |
To store acquisition and cost process status information |
CST_PAC_RECEIVING_VALUES_V |
|
CST_PAC_WIP_TXN_V |
|
CST_PERIOD_BALANCES_VIEW |
Cost summary by cost element for job or repetitive schedule : SINGLE-ORG view |
CST_PERIOD_CG_SUMMARY_V |
This view consolidates the results from MTL_PERIOD_CG_SUMMARY and CST_PERIOD_CLOSE_SUMMARY |
CST_PERIOD_SUMMARY_V |
This view consolidates the results from MTL_PERIOD_SUMMARY and CST_PERIOD_CLOSE_SUMMARY |
CST_PERIOD_VALUE_V |
Used by the View WIP Value form to generate temporary information : SINGLE-ORG view |
CST_PER_CLOSE_DTLS_V |
This view consolidates the results of MTL_PER_CLOSE_DTLS and CST_PERIOD_CLOSE_SUMMARY |
CST_PM_MATL_TXN_V |
Used by concurrent programs for Project Cost Transfer to Oracle Projects |
CST_PM_PENDING_TXN_V |
Identifies material and WIP transactions that have not been cost collected or have errored out in cost collection |
CST_PROJMFG_CMT_BASIC_V |
Manufacturing commitments |
CST_PROJMFG_CMT_STUB_V |
|
CST_PROJMFG_CMT_VIEW |
Manufacturing commitments |
CST_PROJ_EXP_TYPES_VAL_V |
Expenditure types associated with cost elements |
CST_QUANTITY_LAYERS_V |
Item costs for each layer by element and by level |
CST_RCV_RAE_V |
View on the Receiving Accounting events table. Selects information related to the receiving accounting event along with details of the recei |
CST_RCV_RRSL_V |
View on the Receiving Subledger table. Selects details of the receipt accounting. |
CST_RECONCILIATION_CODES |
Holds Accrual Lookups |
CST_RESOURCE_COSTS_V |
Resource costs : SINGLE-ORG view |
CST_RESOURCE_COST_TYPES_V |
Resource and outside processing subelement associations with cost type : SINGLE-ORG view |
CST_RESOURCE_OVERHEADS_V |
Resource based overheads by cost type : SINGLE-ORG view |
CST_ROLLUP_DATE_VIEW |
Cost rollup date : SINGLE-ORG view |
CST_STD_COST_ADJ_TMP1_V |
|
CST_STD_COST_ADJ_TMP2_V |
|
CST_STD_INV_ADJ_VIEW |
Standard cost update adjustment : SINGLE-ORG view |
CST_STD_WIP_ADJ_VIEW |
Standard cost update for jobs or schedules : SINGLE-ORG view |
CST_STD_WMS_INV_ADJ_VIEW |
Standard cost update adjustment |
CST_TOTAL_COST_VIEW |
Total item cost view : SINGLE-ORG view |
CST_WIP_COST_ELEM_VARIANCES_V |
Elemental activity and balance for a job or schedule in an accounting period : SINGLE-ORG view |
CST_WIP_ENTITY_V |
Job or schedule information : SINGLE-ORG view |
CST_WIP_ENTITY_VIEW |
WIP entity information used by the WIP Value inquiry : SINGLE-ORG view |
CST_WIP_LAYER_COSTS_DTLS_V |
|
CST_WIP_PERIOD_BALANCES_V |
Net activity and balance for a job or schedule in an accounting period : SINGLE-ORG view |
CST_WIP_TXN_TYPE_VIEW |
Types of WIP transactions : SINGLE-ORG view |
CST_WIP_VARIANCES_V |
Variance and net activity for a job or schedule for an accounting period : SINGLE-ORG view |
CST_XLA_ACTIVITY_REF_V |
|
CST_XLA_ACTUAL_REF_V |
|
CST_XLA_AWO_HEADERS_V |
|
CST_XLA_AWO_LINES_V |
|
CST_XLA_CHARGE_DEPT_REF_V |
|
CST_XLA_COST_GROUPS_REF_V |
|
CST_XLA_COST_UPDATES_REF_V |
Standard Cost update sources |
CST_XLA_CYCLE_COUNT_REF_V |
|
CST_XLA_DEPARTMENT_REF_V |
|
CST_XLA_DISCRETE_JOB_REF_V |
|
CST_XLA_FLOW_SCHEDULE_REF_V |
|
CST_XLA_HR_EMPLOYEE_REF_V |
|
CST_XLA_HR_ORG_PARAMS_REF_V |
|
CST_XLA_INTERORG_PARAMS_REF_V |
Inter organization GL Accounts for AX backward compatibility |
CST_XLA_INV_CATEGORY_REF_V |
|
CST_XLA_INV_CU_V |
|
CST_XLA_INV_DISPOSITIONS_REF_V |
User defined alias accounts |
CST_XLA_INV_HEADERS_V |
|
CST_XLA_INV_INTRAORG_V |
|
CST_XLA_INV_ITEM_LOCS_REF_V |
|
CST_XLA_INV_ITEM_REVS_REF_V |
|
CST_XLA_INV_LINES_V |
|
CST_XLA_INV_ORG_PARAMS_REF_V |
|
CST_XLA_INV_PO_V |
|
CST_XLA_INV_RCPT_V |
|
CST_XLA_INV_REF_V |
|
CST_XLA_INV_REQ_V |
|
CST_XLA_INV_SEC_INVS_REF_V |
|
CST_XLA_INV_SO_V |
|
CST_XLA_INV_SYSTEM_ITEMS_REF_V |
|
CST_XLA_INV_TXN_SRC_TYPS_REF_V |
|
CST_XLA_INV_TXN_TYPES_REF_V |
|
CST_XLA_INV_UOM_REF_V |
|
CST_XLA_INV_V |
|
CST_XLA_INV_WIP_V |
|
CST_XLA_INV_XFR_V |
|
CST_XLA_MOVE_TXN_REF_V |
|
CST_XLA_OE_ORDER_LINES_REF_V |
|
CST_XLA_OSP_V |
|
CST_XLA_PJM_ORG_PARAMS_REF_V |
|
CST_XLA_PLA_CATEGORY_REF_V |
Product Line Category accounts |
CST_XLA_PO_DIST_REF_V |
|
CST_XLA_PROD_LINE_REF_V |
|
CST_XLA_RCV_HEADERS_V |
|
CST_XLA_RCV_LINES_V |
|
CST_XLA_RCV_REF_V |
|
CST_XLA_RCV_V |
|
CST_XLA_REP_ITEM_REF_V |
|
CST_XLA_REP_SCHED_REF_V |
Repetitive schedule WIP reference object |
CST_XLA_RES_OVH_REF_V |
|
CST_XLA_SHIP_HEADERS_REF_V |
|
CST_XLA_SHIP_LINES_REF_V |
|
CST_XLA_TRF_PLA_CAT_REF_V |
|
CST_XLA_TXN_REASON_REF_V |
|
CST_XLA_WIP_ENTITY_REF_V |
|
CST_XLA_WIP_HEADERS_V |
|
CST_XLA_WIP_LINES_V |
|
CST_XLA_WIP_OPERATION_REF_V |
|
CST_XLA_WIP_OP_RESOURCE_REF_V |
|
CST_XLA_WIP_ORG_PARAMS_REF_V |
|
CST_XLA_WIP_RCV_REF_V |
|
CST_XLA_WIP_V |
|
CST_XLA_WO_V |
|
CZBV_CONFIGURATION_ATTRIBUTES |
- Retrofitted |
CZBV_CONFIGURATION_CONSTRAINTS |
- Retrofitted |
CZBV_CONFIGURATION_OBJECTS |
- Retrofitted |
CZBV_CONFIGURATION_REGIONS |
- Retrofitted |
CZBV_CONFIG_ATTRIBUTE_VALUES |
- Retrofitted |
CZBV_CONFIG_ATTR_LIST_NAMES |
- Retrofitted |
CZBV_CONFIG_ATTR_LIST_VALUES |
- Retrofitted |
CZBV_CONFIG_AUTOSELECT_ITEMS |
- Retrofitted |
CZBV_CONFIG_AUTOSELECT_RANGES |
- Retrofitted |
CZBV_CONFIG_CONSTRAINT_ASSIGNS |
- Retrofitted |
CZBV_CONFIG_CONSTRAINT_CLAUSES |
- Retrofitted |
CZBV_CONFIG_OBJECT_ATTRIBUTES |
- Retrofitted |
CZBV_CONFIG_REGION_ATTRIBUTES |
- Retrofitted |
CZBV_CONFIG_SYSTEM_TYPES |
- Retrofitted |
CZBV_ORDER_LINE_CNFIG_MESSAGES |
- Retrofitted |
CZFV_CONFIGURATION_ATTRIBUTES |
- Retrofitted |
CZFV_CONFIGURATION_CONSTRAINTS |
- Retrofitted |
CZFV_CONFIGURATION_OBJECTS |
- Retrofitted |
CZFV_CONFIGURATION_REGIONS |
- Retrofitted |
CZFV_CONFIG_ATTRIBUTE_VALUES |
- Retrofitted |
CZFV_CONFIG_ATTR_LIST_NAMES |
- Retrofitted |
CZFV_CONFIG_ATTR_LIST_VALUES |
- Retrofitted |
CZFV_CONFIG_AUTOSELECT_ITEMS |
- Retrofitted |
CZFV_CONFIG_AUTOSELECT_RANGES |
- Retrofitted |
CZFV_CONFIG_CONSTRAINT_ASSIGNS |
- Retrofitted |
CZFV_CONFIG_CONSTRAINT_CLAUSES |
- Retrofitted |
CZFV_CONFIG_OBJECT_ATTRIBUTES |
- Retrofitted |
CZFV_CONFIG_REGION_ATTRIBUTES |
- Retrofitted |
CZFV_CONFIG_SYSTEM_TYPES |
- Retrofitted |
CZFV_ORDER_LINE_CNFIG_MESSAGES |
- Retrofitted |
CZ_ATTRIBUTE_LIST_NAMES_V |
Names of attribute lists |
CZ_AUTOSELECTION_ITEMS_V |
Autoselection items |
CZ_AUTOSELECTION_RANGES_V |
Autoselection ranges |
CZ_COMPONENT_SELECTIONS_V |
Selection of components |
CZ_CONSTRAINTS_VL |
Constraints |
CZ_CONSTRAINT_ASSIGNMENTS_V |
Constraint assignments |
CZ_CONSTRAINT_CLAUSES_V |
Constraint clauses |
CZ_CONSTR_ATTR_LEFT_V |
Left hand side of constraint clauses |
CZ_CONSTR_ATTR_RIGHT_V |
Right hand side of constraint clauses |
CZ_ERRORS_SUMMARY_V |
Summary of errors |
CZ_ERRORS_V |
Errors |
CZ_ERROR_ATTRIBUTE_VALUES_V |
Attribute value errors |
CZ_ERROR_CLAUSES_V |
Errors with clauses |
CZ_INST_ATTR_VALUES_V |
Item attribute values |
CZ_ITEM_ATTRIBUTE_VALUES_V |
Item attribute values |
CZ_SYSTEM_COMPONENTS_V |
System components |