MRP Supply Chain Financial Analysis

Description
Categories: BI Publisher, Manufacturing
Application: Master Scheduling/MRP
Source: Supply Chain Financial Analysis Report (XML)
Short Name: MRPRPPIS_XML
DB package: MRP_MRPRPPIT_XMLP_PKG
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
Currency Code
 
LOV Oracle
MRP_SRS_REPORT_START_DATE_STANDARD
 
Date
MRP_SRS_ORG
 
Number
Cost Type
 
LOV Oracle
Weeks
 
LOV Oracle
Periods
 
LOV Oracle
Organization Selection
 
LOV Oracle
Plan Name
 
LOV Oracle