MRP Supply Chain Financial Analysis

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Supply Chain Financial Analysis Report
Application: Master Scheduling/MRP
Source: Supply Chain Financial Analysis Report (XML)
Short Name: MRPRPPIS_XML
DB package: MRP_MRPRPPIT_XMLP_PKG
Run MRP Supply Chain Financial Analysis and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT   plan1.compile_designator ||' - '||plan1.description        C_plan_name ,        
        to_char(plan1.plan_completion_date,'DD-MON-YYYY HH24:MI')  C_plan_date,
        org_v.planned_organization      C_planned_organization,
        pln_sched.INPUT_DESIGNATOR_NAME ||' - '||sched.description                C_schedule_name,
        pln_sched.INPUT_DESIGNATOR_NAME	C_input_designator_name,
        to_char(plan1.cutoff_date,'DD-MON-YYYY')          C_cutoff_date, 
	MRP_MRPRPPIT_XMLP_PKG.c_planned_org_codeformula(org_v.planned_organization) C_planned_org_code, 
	MRP_MRPRPPIT_XMLP_PKG.c_cost_typeformula() C_cost_type
FROM     mrp_plans                 plan1
,        mrp_schedule_designators  sched
,        mrp_plan_schedules_v      pln_sched
,        mrp_plan_organizations_v     org_v
WHERE    sched.organization_id       = pln_sched.INPUT_ORGANIZATION_ID
AND      sched.schedule_designator   = pln_sched.INPUT_DESIGNATOR_NAME
AND      pln_sched.INPUT_ORGANIZATION_ID = org_v.PLANNED_ORGANIZATION
AND      pln_sched.compile_designator = org_v.compile_designator
AND      plan1.organization_id       =  org_v.organization_id
AND      plan1.compile_designator    = org_v.compile_designator
AND      DECODE(:P_ORG_TYPE, 1, org_v.planned_organization,  
                org_v.organization_id)        = :P_ORG_ID
AND      org_v.compile_designator    = :P_PLAN_NAME
Parameter Name SQL text Validation
Plan Name 
 
 LOV Oracle
Organization Selection 
 
 LOV Oracle
Periods 
 
 LOV Oracle
Weeks 
 
 LOV Oracle
Cost Type 
 
 LOV Oracle
Download
Related Blitz Reports
MRP Financial Analysis MSC Plan Orders MRP Supply Chain Order Reschedule MRP Planned Order MRP Supply Chain Late Order MRP Supply Chain Planned Order MRP Order Reschedule MRP Late Order MSC Pegging Hierarchy
Blitz Report™

Blitz Report™ provides multiple benefits: