GME Planned Production

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Planned Production Report of OPM
Application: Process Manufacturing Process Execution
Source: Planned Production (XML)
Short Name: GMEPRACT_XML
DB package: GME_GMEPRACT_XMLP_PKG
Run GME Planned Production and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT         
                    pm.batch_no,
                    rcp.recipe_no ,
                    rcp.recipe_version ,
                    to_char(pm.plan_start_date,'DD-MON-YYYY HH24:MI:SS') plan_start_date ,
                    to_char(pm.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS') expct_cmplt_date , 
                    pm.batch_type, 
	GME_GMEPRACT_XMLP_PKG.cf_batch_typeformula(pm.batch_type) CF_batch_type
FROM
                   gme_batch_header pm,
                   gmd_recipes rcp,
	   gmd_recipe_validity_rules val          
  WHERE   &cf_where and 
                 (plan_start_date >= :from_date1 OR :from_date1 IS NULL) and
                 (plan_start_date < (:to_date1+1) OR :to_date1 IS NULL ) and
                  pm.organization_id = :P_ORG_ID                
                 and pm.recipe_validity_rule_id = val.recipe_validity_rule_id(+)    and 
	 val.recipe_id = rcp.recipe_id(+) and
                  pm.delete_mark = 0               and 
                  pm.batch_status = 1                 
                  ORDER BY &Cf_ord_by
Parameter Name SQL text Validation
From Document 
 
 LOV Oracle
To Document 
 
 LOV Oracle
From Planned Start Date 
 
 Date
To Planned Start Date 
 
 Date
Sort By 
 
 LOV Oracle
Download
Related Blitz Reports
GME Batch Yield Variance OPM Product Qty in batches GME Material Usage and Substitution Variance GME Batch Pick List ECC Process Genealogy and Trace, Process Batch ECC Genealogy and Trace, Process Batch GME Batch Ticket ECC Cost Management, WIP Valuation (Process) ECC Process Manufacturing, Outside Processing Batch
Blitz Report™

Blitz Report™ provides multiple benefits: