OPM Batches
Description
Categories: Draft
Detail report showing the status of the OPM Batches, including basic information
such as plant code, batch number, batch type (0 for normal batches or 10 for firm planned orders), and batch status.
Batches have many steps which are found in GME_BATCH_STEPS. It's not in the
example query; but, the operation name can be found in GMD_OPERATIONS_B
which is linked by OPRN_ID.
more
such as plant code, batch number, batch type (0 for normal batches or 10 for firm planned orders), and batch status.
Batches have many steps which are found in GME_BATCH_STEPS. It's not in the
example query; but, the operation name can be found in GMD_OPERATIONS_B
which is linked by OPRN_ID.
more
select --hou.name, gbh.plant_code plant, --gmd.*, gbh.batch_no "batch num", gmd.item_no, gmd.item_desc, gmd.line_type_meaning, flv.meaning "Batch Status", --trunc(gbh.plan_start_date) "Plan Start", trunc(gbh.actual_start_date) "Actual Start", trunc(gbh.due_date) "Due Date", --trunc(gbh.plan_cmplt_date) plan_complete, trunc(gbh.actual_cmplt_date) "Actual Comp Date", ffmb.attribute4 batch_type, gbs.batchstep_no, gmd.plan_qty, gmd.wip_plan_qty, gmd.actual_qty, -- gbs.plan_step_qty, gbs.actual_step_qty, gbs.backflush_qty, --gbs.plan_start_date, --gbs.actual_start_date, --gbs.due_date, --gbs.plan_cmplt_date, --gbs.actual_cmplt_date, --gbs.step_close_date, gbs.step_status, --gbs.priority_code, --gbs.priority_value, --gbs.delete_mark, --gbs.steprelease_type, --gbs.max_step_capacity, --gbs.max_step_capacity_uom, gbs.plan_charges, --gbs.actual_charges, --gbs.mass_ref_uom, --gbs.plan_mass_qty, --gbs.volume_ref_uom, --gbs.plan_volume_qty, gbs.text_code, gbs.actual_mass_qty, gbs.actual_volume_qty, --gbs.quality_status, --gbs.minimum_transfer_qty, --gbs.terminated_ind, gbs.mass_ref_um, gbs.max_step_capacity_um from gme_batch_header gbh, gme_batch_steps_v gbs, gme_material_details_v gmd, hr_all_organization_units hou, mtl_parameters mp, fnd_lookup_values flv, fm_form_mst_b ffmb where 1=1 AND gbh.batch_id = gmd.batch_id AND gbh.batch_id = gbs.batch_id AND gbh.organization_id = gmd.organization_id -- AND gmd.line_type = '1' --AND gmd.line_no = 1 and gmd.organization_id = hou.organization_id and gmd.organization_id = mp.organization_id AND flv.lookup_code = TO_CHAR(gbh.batch_status) AND flv.lookup_type = 'GME_BATCH_STATUS' AND flv.language = 'US' AND ffmb.formula_id = gbh.formula_id -- and gbh.batch_no = 130810 and gbs.batchstep_no = 10 order by 2 |