You are browsing the archive for Discrete Manufacturing.

Oracle BOM Tables

  • ACTIVITY_COSTS
  • BOM_ALTERNATE_DESIGNATORS
  • BOM_ALTERNATE_DESIGNATORS_TL
  • BOM_ATO_CONFIGS_TEMP
  • BOM_ATO_CONFIGURATIONS
  • BOM_BILLS_HEADER_TEMP
  • BOM_BILL_OF_MATERIALS
  • BOM_BILL_OF_MATERIALS_ARCHIVE
  • BOM_BILL_OF_MATERIALS_TEMP
  • BOM_BILL_OF_MTLS_INTERFACE
  • BOM_BILL_REVISIONS_B
  • BOM_BILL_REVISIONS_TL
  • BOM_CALENDARS
  • BOM_CALENDAR_DATES
  • BOM_CALENDAR_EXCEPTIONS
  • BOM_CALENDAR_SHIFTS
  • BOM_CAL_WEEK_START_DATES
  • BOM_CAL_YEAR_START_DATES
  • BOM_CMP_USR_ATTR_INTERFACE
  • BOM_COMPARISON_TEMP
  • BOM_COMPONENTS_B
  • BOM_COMPONENTS_EXT_B
  • BOM_COMPONENTS_EXT_TL
  • BOM_COMPONENT_COLUMNS
  • BOM_COMPONENT_OPERATIONS
  • BOM_COMPONENT_OPS_INTERFACE
  • BOM_COMPONENT_TYPES
  • BOM_COMP_OPTCLASS_TEMP
  • BOM_COMP_OPTIONS_TEMP
  • BOM_CONFIG_EXPLOSIONS
  • BOM_COPY_ORGANIZATION_LIST
  • BOM_COPY_STRUCTURE_ACTIONS
  • BOM_COPY_STRUCTURE_REQUEST
  • BOM_CTO_MLSUPPLY_MAIN_TEMP
  • BOM_CTO_MODEL_ORGS
  • BOM_CTO_ORDER_DEMAND
  • BOM_CTO_ORDER_LINES
  • BOM_CTO_ORDER_LINES_UPG
  • BOM_CTO_OSS_COMPONENTS
  • BOM_CTO_OSS_ORGS_LIST
  • BOM_CTO_SRC_ORGS
  • BOM_CTO_SRC_ORGS_B
  • BOM_DELETE_ENTITIES
  • BOM_DELETE_ERRORS
  • BOM_DELETE_GROUPS
  • BOM_DELETE_SQL_STATEMENTS
  • BOM_DELETE_SUB_ENTITIES
  • BOM_DEPARTMENTS
  • BOM_DEPARTMENT_CLASSES
  • BOM_DEPARTMENT_RESOURCES
  • BOM_DEPENDENT_DESC_ELEMENTS
  • BOM_DEPEND_DESC_ELEM_ARCHIVE
  • BOM_DEPT_RES_INSTANCES
  • BOM_EAM_DEPT_APPROVERS
  • BOM_EXCEPTION_SETS
  • BOM_EXCEPTION_SET_DATES
  • BOM_EXCLUSION_RULE_ARCHIVE
  • BOM_EXCLUSION_RULE_DEF
  • BOM_EXPLOSIONS
  • BOM_EXPLOSIONS_ALL
  • BOM_EXPLOSION_TEMP
  • BOM_EXPLOSION_TEMP_OLD
  • BOM_FORM_QUERY
  • BOM_IMPLOSION_TEMP
  • BOM_INTERFACE_DELETE_GROUPS
  • BOM_INVENTORY_COMPONENTS
  • BOM_INVENTORY_COMPONENTS_TEMP
  • BOM_INVENTORY_COMPS_ARCHIVE
  • BOM_INVENTORY_COMPS_INTERFACE
  • BOM_INV_COMPONENTS_TEMP
  • BOM_ITEM_ATTACH_CATEGORY_ASSOC
  • BOM_ITEM_BACKFLUSH_SUBINV
  • BOM_LISTS
  • BOM_LOW_LEVEL_CODES
  • BOM_MIXED_MODEL_MAP_CELLS
  • BOM_MIXED_MODEL_MAP_HEADER
  • BOM_MIXED_MODEL_MAP_PROCESSES
  • BOM_MIXED_MODEL_MAP_RES
  • BOM_OPERATIONAL_ROUTINGS
  • BOM_OPERATION_NETWORKS
  • BOM_OPERATION_RESOURCES
  • BOM_OPERATION_RESOURCES_EFC
  • BOM_OPERATION_SEQUENCES
  • BOM_OPERATION_SEQUENCES_TEMP
  • BOM_OPERATION_SKILLS
  • BOM_OP_NETWORKS_INTERFACE
  • BOM_OP_RESOURCES_ARCHIVE
  • BOM_OP_RESOURCES_INTERFACE
  • BOM_OP_ROUTINGS_ARCHIVE
  • BOM_OP_ROUTINGS_INTERFACE
  • BOM_OP_SEQUENCES_ARCHIVE
  • BOM_OP_SEQUENCES_INTERFACE
  • BOM_PARAMETERS
  • BOM_PERIOD_START_DATES
  • BOM_REFERENCE_DESGS_ARCHIVE
  • BOM_REFERENCE_DESIGNATORS
  • BOM_REF_DESGS_INTERFACE
  • BOM_RESOURCES
  • BOM_RESOURCES_EFC
  • BOM_RESOURCE_CHANGES
  • BOM_RESOURCE_DOWNCODES
  • BOM_RESOURCE_EMPLOYEES
  • BOM_RESOURCE_EQUIPMENTS
  • BOM_RESOURCE_FLEX_FENCES
  • BOM_RESOURCE_SETUPS
  • BOM_RESOURCE_SHIFTS
  • BOM_RES_INSTANCE_CHANGES
  • BOM_RTGHEADER_TEMP
  • BOM_RTG_ITEM_REVISIONS_ARCHIVE
  • BOM_RTG_NETWORK_TEMP
  • BOM_RTG_OPERATION_TEMP
  • BOM_RTG_OPER_RES_TEMP
  • BOM_RTG_RESOURCE_TEMP
  • BOM_RTG_SUB_RESOURCE_TEMP
  • BOM_RULES_B
  • BOM_SETUP_TRANSITIONS
  • BOM_SETUP_TYPES
  • BOM_SHIFT_DATES
  • BOM_SHIFT_EXCEPTIONS
  • BOM_SHIFT_TIMES
  • BOM_SMALL_EXPL_TEMP
  • BOM_SMALL_IMPL_TEMP
  • BOM_STANDARD_OPERATIONS
  • BOM_STD_OP_BONUS_CODES
  • BOM_STD_OP_RESOURCES
  • BOM_STD_OP_RESP_EXCLUSIONS
  • BOM_STD_OP_SCRAP_CODES
  • BOM_STD_SUB_OP_RESOURCES
  • BOM_STRUCTURES_B
  • BOM_STRUCTURES_EXT_B
  • BOM_STRUCTURES_EXT_TL
  • BOM_STRUCTURE_EXT_B
  • BOM_STRUCTURE_REVISIONS_B
  • BOM_STRUCTURE_REVISIONS_TL
  • BOM_STRUCTURE_TYPES_B
  • BOM_STRUCTURE_TYPES_TL
  • BOM_SUBSTITUTE_COMPONENTS
  • BOM_SUBSTITUTE_COMPS_ARCHIVE
  • BOM_SUB_COMPS_INTERFACE
  • BOM_SUB_OPERATION_RESOURCES
  • BOM_SUB_OPERATION_RESOURCE_EFC
  • BOM_SUB_OP_RESOURCES_INTERFACE
  • BOM_WORKDAY_PATTERNS
  • CSTGILEV_TEMP
  • CST_ACCOUNTING_LIBRARIES
  • CST_ACCOUNTING_PACKAGES
  • CST_ACCRUAL_ACCOUNTS
  • CST_ACCT_LIB_PACKAGES
  • CST_ACTIVITIES
  • CST_ACTIVITY_COSTS
  • CST_ACTIVITY_COSTS_EFC
  • CST_AE_HEADERS
  • CST_AE_HEADERS_EFC
  • CST_AE_LINES
  • CST_AE_LINES_EFC
  • CST_AP_PO_RECONCILIATION
  • CST_AP_VARIANCE_BATCHES
  • CST_AP_VARIANCE_HEADERS
  • CST_AP_VARIANCE_HEADERS_EFC
  • CST_AP_VARIANCE_LINES
  • CST_AP_VARIANCE_LINES_EFC
  • CST_BIS_MARGIN_BUILD
  • CST_BIS_MARGIN_SUMMARY
  • CST_CAT_ELE_EXP_ASSOCS
  • CST_CG_LIST_TEMP
  • CST_CG_WIP_ACCT_CLASSES
  • CST_COGS_EVENTS
  • CST_COGS_PCT_ADJ_EVENTS_TEMP
  • CST_COGS_QTY_ADJ_EVENTS_TEMP
  • CST_COMP_SNAPSHOT
  • CST_COMP_SNAP_INTERFACE
  • CST_COMP_SNAP_TEMP
  • CST_COST_ELEMENTS
  • CST_COST_ELEM_EXP_TYPES
  • CST_COST_GROUPS
  • CST_COST_GROUP_ACCOUNTS
  • CST_COST_GROUP_ASSIGNMENTS
  • CST_COST_TYPES
  • CST_COST_TYPE_HISTORY
  • CST_COST_UPDATES
  • CST_COST_UPDATES_EFC
  • CST_DEPARTMENT_OVERHEADS
  • CST_DEPARTMENT_OVERHEADS_EFC
  • CST_DEPT_OVERHEADS_INTERFACE
  • CST_DIAG_ERRORED_TXNS
  • CST_DIAG_TXN_ERRORS
  • CST_DISTRIBUTION_MASTER
  • CST_EAM_ACTIVITY_ESTIMATES
  • CST_EAM_ASSET_PER_BALANCES
  • CST_EAM_BALANCE_BY_ACCOUNTS
  • CST_EAM_COST_ELEMENTS
  • CST_EAM_DIRECT_ITEMS_TEMP
  • CST_EAM_HIERARCHY_SNAPSHOT
  • CST_EAM_ROLLUP_COSTS
  • CST_EAM_ROLLUP_TEMP
  • CST_EAM_WO_ESTIMATE_DETAILS
  • CST_ELEMENTAL_COSTS
  • CST_ELEMENTAL_COSTS_EFC
  • CST_ENCUMBRANCE_LINES
  • CST_EXPLOSION_TEMP
  • CST_INQUIRY_TEMP
  • CST_INQUIRY_TYPES
  • CST_INTERFACE_ERRORS
  • CST_INV_COST_TEMP
  • CST_INV_LAYERS
  • CST_INV_LAYER_COST_DETAILS
  • CST_INV_QTY_TEMP
  • CST_ITEM_COSTS
  • CST_ITEM_COSTS_EFC
  • CST_ITEM_COSTS_INTERFACE
  • CST_ITEM_COSTS_TEMP
  • CST_ITEM_COST_DETAILS
  • CST_ITEM_COST_DETAILS_EFC
  • CST_ITEM_CST_DTLS_INTERFACE
  • CST_ITEM_LIST_TEMP
  • CST_ITEM_OVERHEAD_DEFAULTS
  • CST_ITEM_OVERHEAD_DEFAULTS_EFC
  • CST_LAYER_COST_DETAILS
  • CST_LAYER_COST_DETAILS_EFC
  • CST_LC_ACCOUNTS_GT
  • CST_LC_ADJ_ACCTG_INFO_GT
  • CST_LC_ADJ_INTERFACE
  • CST_LC_ADJ_INTERFACE_ERRORS
  • CST_LC_ADJ_TRANSACTIONS
  • CST_LC_MMT_GT
  • CST_LC_RAE_EVENTS_GT
  • CST_LC_RCV_TXN_GT
  • CST_LE_COST_TYPES
  • CST_LISTS
  • CST_LOW_LEVEL_CODES
  • CST_MARGIN_BUILD
  • CST_MARGIN_SUMMARY
  • CST_MARGIN_TEMP
  • CST_MASS_EDITS
  • CST_MATERIAL_OVHD_RULES
  • CST_MGD_IAL_INVALID_MMT
  • CST_MGD_INFL_ADJUSTED_COSTS
  • CST_MGD_INFL_ADJ_KARDEX_DATA
  • CST_MGD_INFL_ADJ_PER_STATUSES
  • CST_MGD_INFL_TSF_ORG_ENTRIES
  • CST_MGD_MSTR_BOOK_TEMP
  • CST_MISC_RECONCILIATION
  • CST_ORG_COST_GROUP_ACCOUNTS
  • CST_OSFM_UPGRADE_TEMP
  • CST_PAC_ACCRUAL_ACCOUNTS_TEMP
  • CST_PAC_ACCRUAL_RECONCILE_TEMP
  • CST_PAC_ACCRUAL_WRITE_OFFS
  • CST_PAC_ACCRUAL_WRITE_OFFS_EFC
  • CST_PAC_EAM_ASSET_PER_BALANCES
  • CST_PAC_EAM_BALANCE_BY_ACCTS
  • CST_PAC_EAM_PERIOD_BALANCES
  • CST_PAC_EAM_WO_EST_STATUSES
  • CST_PAC_EXPLOSION_TEMP
  • CST_PAC_INTERORG_TXNS_TMP
  • CST_PAC_INTORG_ITMS_TEMP
  • CST_PAC_ITEM_COSTS
  • CST_PAC_ITEM_COSTS_EFC
  • CST_PAC_ITEM_COST_DETAILS
  • CST_PAC_ITEM_COST_DETAILS_EFC
  • CST_PAC_ITMS_ABSL_CODES
  • CST_PAC_LOW_LEVEL_CODES
  • CST_PAC_PERIODS
  • CST_PAC_PERIOD_BALANCES
  • CST_PAC_PROCESS_PHASES
  • CST_PAC_QUANTITY_LAYERS
  • CST_PAC_REQ_OPER_COST_DETAILS
  • CST_PC_COST_DET_INTERFACE
  • CST_PC_ITEM_COST_INTERFACE
  • CST_PC_TXN_HISTORY
  • CST_PERIOD_CLOSE_SUMMARY
  • CST_PERIOD_VALUE_TEMP
  • CST_PER_END_ACCRUALS_TEMP
  • CST_PM_MATL_TXNS_TEMP
  • CST_QUANTITY_LAYERS
  • CST_QUANTITY_LAYERS_EFC
  • CST_RCV_ACQ_COSTS
  • CST_RCV_ACQ_COSTS_ADJ
  • CST_RCV_ACQ_COSTS_EFC
  • CST_RCV_ACQ_COST_DETAILS
  • CST_RCV_ACQ_COST_DETAILS_ADJ
  • CST_RCV_ACQ_COST_DETAILS_EFC
  • CST_RECONCILIATION_BUILD
  • CST_RECONCILIATION_GTT
  • CST_RECONCILIATION_SUMMARY
  • CST_REPORT_TYPES
  • CST_RESOURCE_COSTS
  • CST_RESOURCE_COSTS_EFC
  • CST_RESOURCE_COSTS_INTERFACE
  • CST_RESOURCE_OVERHEADS
  • CST_RES_OVERHEADS_INTERFACE
  • CST_REVENUE_COGS_CONTROL
  • CST_REVENUE_COGS_MATCH_LINES
  • CST_REVENUE_RECOGNITION_LINES
  • CST_ROLLUP_DELETE_TEMP
  • CST_SC_BOM_EXPLOSION
  • CST_SC_BOM_STRUCTURES
  • CST_SC_LISTS
  • CST_SC_LOW_LEVEL_CODES
  • CST_SC_ROLLUP_HISTORY
  • CST_SC_SOURCING_RULES
  • CST_STANDARD_COSTS
  • CST_STANDARD_COSTS_EFC
  • CST_STD_COST_ADJ_DEBUG
  • CST_STD_COST_ADJ_TEMP
  • CST_STD_COST_ADJ_VALUES
  • CST_STD_COST_ADJ_VALUES_EFC
  • CST_SUB_LIST_TEMP
  • CST_VALUE_REPORT_TEMP
  • CST_WIP_LAYERS
  • CST_WIP_LAYER_COST_DETAILS
  • CST_WIP_OPERATION_TXN_COSTS
  • CST_WIP_PAC_PERIOD_BAL_TMP
  • CST_WIP_VALUE_HISTORY
  • CST_WRITE_OFFS
  • CST_WRITE_OFF_DETAILS
  • CST_XLA_INV_EVENT_MAP
  • CST_XLA_RCV_EVENT_MAP
  • CST_XLA_SEQ_GT
  • CST_XLA_WIP_EVENT_MAP
  • CZ_ATTRIBUTE_LIST_NAMES
  • CZ_ATTRIBUTE_LIST_VALUES
  • CZ_AUTOSELECTION_ITEMS
  • CZ_AUTOSELECTION_RANGES
  • CZ_CONSTRAINTS
  • CZ_CONSTRAINT_ASSIGNMENTS
  • CZ_CONSTRAINT_CLAUSES
  • CZ_CONSTRAINT_MESSAGES_TL
  • CZ_ERRORS
  • CZ_ERROR_ATTRIBUTE_VALUES
  • CZ_ERROR_CLAUSES

Oracle Engineering Tables

Oracle Engineering Tables

  • ENG_ATTACHMENT_CHANGES
  • ENG_ATTRIBUTES_SECTIONS_B
  • ENG_ATTRIBUTES_SECTIONS_TL
  • ENG_AUTO_NUMBER_ECN
  • ENG_CATEGORY_RELATIONSHIPS
  • ENG_CATEGORY_SUBJECTS
  • ENG_CHANGES_EXT
  • ENG_CHANGES_EXT_B
  • ENG_CHANGES_EXT_TL
  • ENG_CHANGE_ACTIONS
  • ENG_CHANGE_ACTIONS_TL
  • ENG_CHANGE_CLASSIFICATIONS_B
  • ENG_CHANGE_CLASSIFICATIONS_TL
  • ENG_CHANGE_IMTEXT_TL
  • ENG_CHANGE_LINES
  • ENG_CHANGE_LINES_EXT
  • ENG_CHANGE_LINES_EXT_B
  • ENG_CHANGE_LINES_EXT_TL
  • ENG_CHANGE_LINES_INTERFACE
  • ENG_CHANGE_LINES_TL
  • ENG_CHANGE_LOCAL_ORGS
  • ENG_CHANGE_LOGS_B
  • ENG_CHANGE_LOGS_TL
  • ENG_CHANGE_MGMT_TYPES
  • ENG_CHANGE_MGMT_TYPES_TL
  • ENG_CHANGE_OBJECTS
  • ENG_CHANGE_OBJECTS_TL
  • ENG_CHANGE_OBJ_ACTIONS
  • ENG_CHANGE_OBJ_ACTIONS_TL
  • ENG_CHANGE_OBJ_RELATIONSHIPS
  • ENG_CHANGE_ORDER_REVISIONS
  • ENG_CHANGE_ORDER_TYPES
  • ENG_CHANGE_ORDER_TYPES_TL
  • ENG_CHANGE_PEOPLE_INTF
  • ENG_CHANGE_POLICIES
  • ENG_CHANGE_POLICY_APPROVERS
  • ENG_CHANGE_POLICY_VALUES
  • ENG_CHANGE_PRIORITIES
  • ENG_CHANGE_PROPAGATION_MAPS
  • ENG_CHANGE_REASONS
  • ENG_CHANGE_ROLES_TEMP
  • ENG_CHANGE_ROUTES
  • ENG_CHANGE_ROUTES_TL
  • ENG_CHANGE_ROUTE_ASSOCS
  • ENG_CHANGE_ROUTE_PEOPLE
  • ENG_CHANGE_ROUTE_PEOPLE_TL
  • ENG_CHANGE_ROUTE_STEPS
  • ENG_CHANGE_ROUTE_STEPS_TL
  • ENG_CHANGE_RULES
  • ENG_CHANGE_RULE_ATTRIBUTES_B
  • ENG_CHANGE_RULE_ATTRIBUTES_TL
  • ENG_CHANGE_STATUSES
  • ENG_CHANGE_STATUSES_TL
  • ENG_CHANGE_SUBJECTS
  • ENG_CHANGE_TASKS_B
  • ENG_CHANGE_TASKS_TL
  • ENG_CHANGE_TEMPLATES_B
  • ENG_CHANGE_TEMPLATES_TL
  • ENG_CHANGE_TYPE_APPLICATIONS
  • ENG_CHANGE_TYPE_CLASS_CODES
  • ENG_CHANGE_TYPE_ORG_TASKS
  • ENG_CHANGE_TYPE_PRIORITIES
  • ENG_CHANGE_TYPE_PROCESSES
  • ENG_CHANGE_TYPE_REASONS
  • ENG_CHANGE_TYPE_ROUTES
  • ENG_CHG_USR_ATR_INTERFACE
  • ENG_CURRENT_SCHEDULED_DATES
  • ENG_ECN_APPROVAL_LISTS
  • ENG_ECN_APPROVERS
  • ENG_ECO_REVISIONS_INTERFACE
  • ENG_ECO_SUBMIT_REVISIONS
  • ENG_ENGINEERING_CHANGES
  • ENG_ENG_CHANGES_INTERFACE
  • ENG_LIFECYCLE_STATUSES
  • ENG_LOGIN_ACCESS_CHANGES
  • ENG_ORG_HIERARCHY_POLICIES
  • ENG_PENDING_CHANGE_CTX
  • ENG_RELATIONSHIP_CHANGES
  • ENG_REVISED_COMPONENTS
  • ENG_REVISED_ITEMS
  • ENG_REVISED_ITEMS_INTERFACE
  • ENG_REVISED_OPERATIONS
  • ENG_STATUS_PROPERTIES
  • ENG_SUBJECTS_B
  • ENG_SUBJECTS_TL
  • ENG_SUBJECT_ENTITIES
  • ENG_TYPE_ORG_HIERARCHIES
  • ENG_TYPE_ORG_PROPERTIES

Oracle WIP Forms

Oracle Work In Process forms:

FORM SHORT CODE ORACLE FORM NAME
WIPDJMDF Define Discrete Job
WIPJSINT Pending Jobs and Schedules
WIPMRMDF Material Requirements
WIPMRQAW Material Requirements across WIP
WIPOPMDF Update WIP Operations
WIPOPQAW Operations across WIP
WIPPCBDW Discrete Workstation
WIPPCBFW Flow Workstation
WIPREMAL Repetitive Line/Assembly Associations
WIPREMDF Define Repetitive Schedules
WIPREMLN Production Line
WIPRRQAW Resource Requirements across WIP
WIPSGMDF Schedule Groups
WIPSTMSC Update Shop Floor Statuses
WIPSUMCL Define WIP Accounting Class
WIPSUMLR Employee Labor Rates
WIPSUMPM Define Work in Process Parameters
WIPSUMST Define Shop Floor Statuses
WIPTIRSC Resource Transactions Interface
WIPTISFM Move Transactions Interface
WIPTQJLC Job Lot Composition
WIPTQRSC View Resource Transactions
WIPTQSFM View Move Transactions
WIPTXCFM Work Order-less Completions
WIPTXCMP Completion Transactions
WIPTXMAT WIP Material Transactions
WIPTXRSC Resource Transactions
WIPTXSFM Move Transactions
WIPCMPPK Component Pick Release
WMA_MOBILE_FORM WMA Mobile Forms
WIPZJBWB Job Workbench
WIPZRSWB Resource Workbench
WIPZEMWB Scheduler Workbench