You are browsing the archive for Discrete Manufacturing.

Views in Oracle Shop Floor Management Module

List of views in Oracle Shop Floor Management Module

WSM_ALL_OPERATIONS_V
WSM_CO_PROD_COMP_SUBSTITUT_DFV
WSM_CO_PROD_COMP_SUBSTITUTES_V
WSM_CO_PROD_SUBSTITUTES_DFV
WSM_CO_PRODUCT_COMPONENTS_V
WSM_CO_PRODUCTS_DFV
WSM_CO_PRODUCTS_V
WSM_COMPONENTS_V
WSM_COPRODUCT_SPLIT_DATES_V
WSM_COPRODUCT_SPLIT_PERC_V
WSM_COPY_ALL_OPERATIONS_V
WSM_COPY_NEXT_OPERATIONS_V
WSM_DISCRETE_JOBS_LOTATTR_V
WSM_DISCRETE_JOBS_V
WSM_INV_GENEALOGY_V
WSM_INV_TXNS_WIP_LOTS_V
WSM_ITEM_EXTENSIONS_V
WSM_JOB_SERIAL_NUMBERS_V
WSM_LBJ_FOR_RESERVATIONS_V
WSM_LOT_SPLIT_MERGES_DFV
WSM_NEXT_OPERATIONS_V
WSM_OPERATION_DETAILS_V
WSM_RES_JOB_SERIAL_NUMS_V
WSM_RESERVATIONS_V
WSM_SERIAL_MOVE_GENEALOGY_V
WSM_SM_RESULTING_JOBS_DFV
WSM_SM_RESULTING_JOBS_V
WSM_SM_RESULTING_LOTS_DFV
WSM_SM_STARTING_JOBS_DFV
WSM_SM_STARTING_JOBS_V
WSM_SM_STARTING_LOTS_DFV
WSM_SOURCE_LOTS_V
WSM_SPLIT_MERGE_TRANSACTIO_DFV
WSM_STANDARD_CLASSES_VAL_V
WSM_START_JOB_SERIAL_NUMS_V
WSM_WIP_GENEALOGY_LOTATTR_V
WSM_WIP_GENEALOGY_V
WSM_WIP_LOT_TXNS_V
WSM_WIP_OPERATIONS_V
WSM_WLT_SERIAL_GENEALOGY_V

Views in Oracle Work In Process Module

List of views in Oracle WIP module

WIP_ACCOUNTING_CLASSES_DFV
WIP_ACCOUNTING_CLASSES1_DFV
WIP_ACTIVE_DISCRETE_JOBS_VAL_V
WIP_BIS_LATE_PROD_COMP_V
WIP_BIS_PERF_TO_PLAN_V
WIP_BIS_PERIOD_BALANCE_V
WIP_BIS_PROD_ASSY_YIELD_V
WIP_BIS_PROD_DEPT_YIELD_V
WIP_BIS_PROD_VAL_EMP_V
WIP_BIS_PRODUCTIVITIES_V
WIP_BIS_SCRAP_REASONS_V
WIP_BIS_UTZ_CAT_V
WIP_BIS_UTZ_CATNOITEM_V
WIP_BIS_UTZ_NOCAT_V
WIP_COMMENT_CODES_V
WIP_COMP_SALES_ORDERS_VAL_V
WIP_COST_TXN_INTERFACE_DFV
WIP_COST_TXN_INTERFACE_V
WIP_CUMULATIVE_SCRAP_V
WIP_CUR_NET_AVAILABLE_VIEW
WIP_CUR_SUB_LOC_NET_AVAIL_VIEW
WIP_DEF_CAT_ACC_CLASSES_V
WIP_DEPT_IMM_DISPATCH_V
WIP_DEPT_RESOURCES_V
WIP_DEPT_UPS_DISPATCH_V
WIP_DISC_INTRAOP_STEPS_VAL_V
WIP_DISCRETE_CLASSES_ALL_V
WIP_DISCRETE_JOBS_ALL_V
WIP_DISCRETE_JOBS_DFV
WIP_DISCRETE_JOBS_V
WIP_EAM_COST_DETAILS_V
WIP_EAM_CST_HEADER_V
WIP_EAM_DIRECT_ITEMS_V
WIP_EAM_ENTITIES_V
WIP_EAM_NEXT_OPERATIONS_V
WIP_EAM_OP_COST_DETAILS_V
WIP_EAM_OSP_V
WIP_EAM_PARAMETERS_V
WIP_EAM_PRIOR_OPERATIONS_V
WIP_EAM_REQUIREMENTS_ALL_V
WIP_EAM_WO_SRV_ASSOC_V
WIP_EAM_WORK_ORDER_DTLS_V
WIP_EAM_WORK_ORDERS_V
WIP_EAM_WORK_REQUESTS_DFV
WIP_EAM_WORK_REQUESTS_V
WIP_EMPLOYEE_LABOR_RATES_DFV
WIP_ENTITY_COMMENTS_V
WIP_EXCEPTIONS_DFV
WIP_EXPLOSIONS_V
WIP_FIRST_ACTIVE_SCHEDULE_V
WIP_FIRST_OPEN_SCHEDULE_V
WIP_FIRST_TXN_SCHEDULE_V
WIP_FLOW_ASSEMBLIES_V
WIP_FLOW_ASSEMBLY_EVENTS_V
WIP_FLOW_LINE_LINEARITY_V
WIP_FLOW_MIX_LINEARITY_V
WIP_FLOW_OPEN_ALLOCATIONS_V
WIP_FLOW_SCHEDULE_EVENTS_V
WIP_FLOW_SCHEDULES_DFV
WIP_FLOW_SCHEDULES_V
WIP_ICX_COMPONENTS_V
WIP_ICX_OSP_WORKBENCH_V
WIP_INST_EMP_IMM_DISPATCH_V
WIP_INST_EMP_UPS_DISPATCH_V
WIP_INST_EQP_IMM_DISPATCH_V
WIP_INST_EQP_UPS_DISPATCH_V
WIP_INTERFACE_ERRORS_V
WIP_JOB_ASSY_LINE_V
WIP_JOB_LOT_COMPOSITION_V
WIP_JOB_OPEN_ALLOCATIONS_V
WIP_JOB_SCHEDULE_INTERFACE_V
WIP_JOB_SERIAL_NUMBERS_V
WIP_JOBS_AND_SCHEDULES_V
WIP_JOBS_RESERVATIONS_V
WIP_LINE_OPERATIONS_V
WIP_LINES_ALL_V
WIP_LINES_DFV
WIP_LINES_VAL_V
WIP_LOTJOB_OPEN_ALLOCATIONS_V
WIP_MATERIAL_SHORTAGES_V
WIP_MOVE_TRANSACTIONS_V
WIP_MOVE_TXN_INTERFACE_DFV
WIP_MOVE_TXN_INTERFACE_V
WIP_NET_AVAILABLE_VIEW
WIP_NON_STANDARD_CLASSES_VAL_V
WIP_ON_DISCRETE_JOBS_V
WIP_OP_RES_INSTANCE_USAGE_V
WIP_OP_RESOURCE_INSTANCES_V
WIP_OPEN_DEMANDS_V
WIP_OPEN_DISCRETE_JOBS_VAL_V
WIP_OPEN_FLOW_SCHEDULES_V
WIP_OPEN_SCHEDULES_VAL_V
WIP_OPERATION_INSTRUCTIONS_V
WIP_OPERATION_RESOURCE_USAGE_V
WIP_OPERATION_RESOURCES_INQ_V
WIP_OPERATION_RESOURCES_V
WIP_OPERATION_SKILLS_V
WIP_OPERATIONS_ALL_V
WIP_OPERATIONS_INQ_V
WIP_OPERATIONS_V
WIP_OSP_DEST_OPERATION_V
WIP_OSP_JOBS_VAL_V
WIP_OSP_LINES_VAL_V
WIP_OSP_OPERATIONS_VAL_V
WIP_OSP_REP_ASSY_VAL_V
WIP_OSP_REP_SCHED_VAL_V
WIP_OSP_REQS_POS_V
WIP_OSP_RESOURCES_VAL_V
WIP_PARAMETERS_DFV
WIP_PARAMETERS_V
WIP_PCB_BOM_DEPARTMENTS_V
WIP_PCB_DEPT_IMM_DISPATCH_V
WIP_PCB_DEPT_RESOURCES_V
WIP_PCB_DEPT_UPS_DISPATCH_V
WIP_PCB_EMP_IMM_DISPATCH_V
WIP_PCB_EMP_UPS_DISPATCH_V
WIP_PCB_EQP_IMM_DISPATCH_V
WIP_PCB_EQP_UPS_DISPATCH_V
WIP_PCB_FLOW_ASSEMBLIES_V
WIP_PCB_FLOW_ASSEMBLY_EVENTS_V
WIP_PCB_FLOW_SCHEDULE_EVENTS_V
WIP_PCB_OPEN_FLOW_SCHEDULES_V
WIP_PCB_RES_IMM_DISPATCH_V
WIP_PCB_RES_INST_EMPLOYEES_V
WIP_PCB_RES_INST_EQUIPMENTS_V
WIP_PCB_RES_UPS_DISPATCH_V
WIP_REP_ASSY_VAL_V
WIP_REP_INTRAOP_STEPS_VAL_V
WIP_REP_OPEN_ALLOCATIONS_V
WIP_REP_QUANTITY_SCRAPPED_V
WIP_REPETITIVE_CLASSES_VAL_V
WIP_REPETITIVE_ENTITIES_V
WIP_REPETITIVE_ITEMS_V
WIP_REPETITIVE_SCHEDULES_DFV
WIP_REPETITIVE_SCHEDULES_V
WIP_REQUIREMENT_OPERATIONS_V
WIP_REQUIREMENT_OPS_INQ_V
WIP_RES_IMM_DISPATCH_V
WIP_RES_INST_EMPLOYEES_V
WIP_RES_INST_EQUIPMENTS_V
WIP_RES_UNITS_WORKED_VIEW
WIP_RES_UPS_DISPATCH_V
WIP_RESERVATIONS_V
WIP_RET_SALES_ORDERS_VAL_V
WIP_SALES_ORDER_LINES_V
WIP_SCHEDULE_GROUPS_DFV
WIP_SCHEDULE_GROUPS_VAL_V
WIP_SCHEDULING_ERRORS_V
WIP_SCHEDULING_EXCEPTIONS_V
WIP_SHOP_FLOOR_STATUS_CODE_DFV
WIP_SHOP_FLOOR_STATUSES_V
WIP_SHOP_FLOOR_STATUSES_VAL_V
WIP_SO_ALLOCATIONS_V
WIP_STANDARD_CLASSES_VAL_V
WIP_SUB_LOC_NET_AVAIL_VIEW
WIP_SUB_OPERATION_RESOURCES_V
WIP_TRANSACTIONS_DFV
WIP_TRANSACTIONS_V
WIP_TX_REP_INTRAOP_STEPS_VAL_V
WIP_TXN_COMP_INTERFACE_V
WIP_TXN_DISCRETE_JOBS_VAL_V
WIP_TXN_REP_ASSY_VAL_V
WIP_VALID_INTRAOPERATION_S_DFV
WIP_WORKFLOW_V
WIP_WS_PTPKPI_AGG_V
WIPBV_ACCOUNTING_CLASSES
WIPBV_FLOW_SCHED_COMPS
WIPBV_FLOW_SCHEDULES
WIPBV_INTRAOP_STEP_STATUSES
WIPBV_JOB_CLOSE_VARIANCE_TXNS
WIPBV_MFG_COST_UPDATE_TXNS
WIPBV_MFG_ORDERS
WIPBV_MFG_RESOURCE_TXNS
WIPBV_MFG_TRANSACTIONS
WIPBV_MTL_TXN_ALLOCATIONS
WIPBV_OSP_MFG_TXNS
WIPBV_OVERHEAD_MFG_TXNS
WIPBV_PERIOD_CLOSE_VAR_TXNS
WIPBV_REPETITIVE_SCHEDULES
WIPBV_WIP_COMPONENTS
WIPBV_WIP_EMPLOYEE_LABOR_RATES
WIPBV_WIP_INTRAOPERATION_STEPS
WIPBV_WIP_JOBS
WIPBV_WIP_MOVE_TRANSACTIONS
WIPBV_WIP_MOVE_TXN_ALLOCATIONS
WIPBV_WIP_OPERATION_RESOURCES
WIPBV_WIP_OPERATIONS
WIPBV_WIP_PERIOD_BALANCES
WIPBV_WIP_REPETITIVE_ITEMS
WIPBV_WIP_RESERVATIONS
WIPBV_WIP_SCHEDULE_GROUPS
WIPBV_WIP_STATUS_CODES
WIPBV_WIP_TXN_ALLOCATIONS
WIPFV_ACCOUNTING_CLASSES
WIPFV_FLOW_SCHED_COMPS
WIPFV_FLOW_SCHEDULES
WIPFV_INTRAOP_STEP_STATUSES
WIPFV_JOB_CLOSE_VARIANCE_TXNS
WIPFV_MFG_COST_UPDATE_TXNS
WIPFV_MFG_ORDERS
WIPFV_MFG_RESOURCE_TXNS
WIPFV_MFG_TRANSACTIONS
WIPFV_MTL_TXN_ALLOCATIONS
WIPFV_OSP_MFG_TXNS
WIPFV_OVERHEAD_MFG_TXNS
WIPFV_PERIOD_CLOSE_VAR_TXNS
WIPFV_REPETITIVE_SCHEDULES
WIPFV_WIP_COMPONENTS
WIPFV_WIP_EMPLOYEE_LABOR_RATES
WIPFV_WIP_INTRAOPERATION_STEPS
WIPFV_WIP_JOBS
WIPFV_WIP_MOVE_TRANSACTIONS
WIPFV_WIP_MOVE_TXN_ALLOCATIONS
WIPFV_WIP_OPERATION_RESOURCES
WIPFV_WIP_OPERATIONS
WIPFV_WIP_PERIOD_BALANCES
WIPFV_WIP_REPETITIVE_ITEMS
WIPFV_WIP_RESERVATIONS
WIPFV_WIP_SCHEDULE_GROUPS
WIPFV_WIP_STATUS_CODES
WIPFV_WIP_TXN_ALLOCATIONS

Views in Oracle Quality Module

List of Views in Oracle Quality Module

QA_ACTION_LOG_V
QA_BIS_RESULTS_V
QA_CHAR_ACTION_OUTPUTS_V
QA_CHAR_ACTION_TRIGGERS_V
QA_CHAR_ACTIONS_V
QA_CHAR_VALUE_LOOKUPS_DFV
QA_CHAR_VALUE_LOOKUPS_V
QA_CHARS_DFV
QA_CHARS_V
QA_CRITERIA_HEADERS_V
QA_CRITERIA_V
QA_CRITERIA_V1
QA_CUSTOMERS_LOV_V
QA_DEVICE_DATA_VALUES_V
QA_ERES_INTEGRATION_PLANS_V
QA_ERES_PC_RESULTS_REL_V
QA_ERES_PLAN_CHAR_ACTIONS_V
QA_ERES_PLANS_V
QA_ERES_RCV_TRANS_INTERFACE_V
QA_ERES_SPECS_V
QA_ERES_WSH_DELIVERABLES_V
QA_ERES_WSH_NEW_DELIVERIES_V
QA_GLOBAL_RESULTS_V
QA_GRANTED_PRIVILEGES_V
QA_GROUP_V
QA_HZ_PARTY_RELATIONSHIPS_V
QA_IN_LISTS_V
QA_LOOKUPS
QA_MQA_COLLECTION_TRIGGERS_V
QA_PC_CRITERIA_COLUMNS_V
QA_PC_PLAN_COLUMNS_V
QA_PC_RESULT_COLUMNS_V
QA_PC_RESULTS_RELATIONSHIP_V
QA_PLAN_CHAR_ACTION_OUTPUTS_V
QA_PLAN_CHAR_ACTION_TRIGGERS_V
QA_PLAN_CHAR_ACTIONS_V
QA_PLAN_CHARS_DFV
QA_PLAN_CHARS_V
QA_PLAN_COLLECTION_TRIGGERS_V
QA_PLAN_TRANSACTIONS_V
QA_PLANS_DFV
QA_PLANS_V
QA_PLANS_VAL_V
QA_PO_NUMBERS_LOV_V
QA_RESULTS_FULL_V
QA_RESULTS_QWB_V
QA_RESULTS_V
QA_RESULTS_VAL_V
QA_SALES_ORDERS_LOV_V
QA_SAMPLING_PLANS_V
QA_SAMPLING_RCV_CRITERIA_V
QA_SAMPLING_RCV_CRITERIA_VAL_V
QA_SEQ_AUDIT_HISTORY_V
QA_SKIPLOT_PLAN_STATE_V
QA_SKIPLOT_PROCESS_PLANS_V
QA_SKIPLOT_PROCESSES_V
QA_SKIPLOT_RCV_CRITERIA_V
QA_SKIPLOT_RCV_CRITERIA_VAL_V
QA_SKIPLOT_RCV_RESULTS_V
QA_SKIPLOT_STATE_HISTORY_V
QA_SL_CRITERIA_ASSOCIATION_V
QA_SL_SP_RCV_CRITERIA_ALL_V
QA_SL_SP_RCV_CRITERIA_V
QA_SP_CRITERIA_ASSOCIATION_V
QA_SPEC_CHARS_DFV
QA_SPEC_CHARS_V
QA_SPEC_CHARS_VAL_V
QA_SPEC_ORG_ASSIGNMENTS_V
QA_SPEC_ORGS_V
QA_SPECS_DFV
QA_SPECS_V
QA_SPECS_VAL_V
QA_TXN_COLLECTION_TRIGGERS_V
QA_USER_GROUP_V
QABV_COLELMACTN
QABV_COLELMACTT
QABV_COLLECTION_ELEMENTS
QABV_COLLECTION_PLAN_ELEMENTS
QABV_COLLECTION_PLANS
QABV_COLPLNELAC
QABV_COLPLNTXN
QABV_COLPLNTXNT
QABV_PLNELMACTT
QABV_QUALITY_ACTION_TYPES
QABV_QUALITY_SPECIFICATIONS
QABV_QUALSPCELM
QAFV_COLELMACTN
QAFV_COLELMACTT
QAFV_COLLECTION_ELEMENTS
QAFV_COLLECTION_PLAN_ELEMENTS
QAFV_COLLECTION_PLANS
QAFV_COLPLNELAC
QAFV_COLPLNTXN
QAFV_COLPLNTXNT
QAFV_PLNELMACTT
QAFV_QUALITY_ACTION_TYPES
QAFV_QUALITY_SPECIFICATIONS
QAFV_QUALSPCELM