MRP Supply Chain Financial Analysis
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
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 |