FLM Flow Linearity

Description
Categories: BI Publisher, Manufacturing
Application: Flow Manufacturing
Source: Flow Linearity Report (XML)
Short Name: FLMRFLIN_XML
DB package: FLM_FLMRFLIN_XMLP_PKG
select msi1.inventory_item_id assembly_id2,
   &P_ASSY_FLEX C_ASSY_FLEX2,
   date1 week_start_date2,
   char1 line_code2,
   char2 schedule_group2,
   number1 day1_plan2,
   number2 day2_plan2,
   number3 day3_plan2,
   number4 day4_plan2,
   number5 day5_plan2,
   number6 day6_plan2,
   number7 day7_plan2,
   number8 day1_actual2,
   number9 day2_actual2,
   number10 day3_actual2,
   number11 day4_actual2,
   number12 day5_actual2,
   number13 day6_actual2,
   number14 day7_actual2,
   number1-number8 day1_var2,
   number2-number9 day2_var2,
   number3-number10 day3_var2,
   number4-number11 day4_var2,
   number5-number12 day5_var2,
   number6-number13 day6_var2,
   number7-number14 day7_var2, 
	/*FLM_FLMRFLIN_XMLP_PKG.day1_var_line2formula(:day1_plan_line2, :day1_actual_line2) day1_var_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day1_lin_line2formula(:day1_plan_line2, :day1_actual_line2) day1_lin_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day2_var_line2formula(:day2_plan_line2, :day2_actual_line2) day2_var_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day2_lin_line2formula(:day2_plan_line2, :day2_actual_line2) day2_lin_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day3_var_line2formula(:day3_plan_line2, :day3_actual_line2) day3_var_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day3_lin_line2formula(:day3_plan_line2, :day3_actual_line2) day3_lin_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day4_var_line2formula(:day4_plan_line2, :day4_actual_line2) day4_var_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day4_lin_line2formula(:day4_plan_line2, :day4_actual_line2) day4_lin_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day5_var_line2formula(:day5_plan_line2, :day5_actual_line2) day5_var_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day5_lin_line2formula(:day5_plan_line2, :day5_actual_line2) day5_lin_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day6_var_line2formula(:day6_plan_line2, :day6_actual_line2) day6_var_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day6_lin_line2formula(:day6_plan_line2, :day6_actual_line2) day6_lin_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day7_var_line2formula(:day7_plan_line2, :day7_actual_line2) day7_var_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day7_lin_line2formula(:day7_plan_line2, :day7_actual_line2) day7_lin_line2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_plan_line2formula(:day1_plan_line2, :day2_plan_line2, :day3_plan_line2, :day4_plan_line2, :day5_plan_line2, :day6_plan_line2, :day7_plan_line2) weekly_plan_line2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_actual_line2formula(:day1_actual_line2, :day2_actual_line2, :day3_actual_line2, :day4_actual_line2, :day5_actual_line2, :day6_actual_line2, :day7_actual_line2) weekly_actual_line2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_var_line2formula(:weekly_plan_line2, :weekly_actual_line2) weekly_var_line2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_lin_line2formula(:weekly_plan_line2, :weekly_actual_line2) weekly_lin_line2, 
	FLM_FLMRFLIN_XMLP_PKG.day1_var_group2formula(:day1_plan_group2, :day1_actual_group2) day1_var_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day1_lin_group2formula(:day1_plan_group2, :day1_actual_group2) day1_lin_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day2_var_group2formula(:day2_plan_group2, :day2_actual_group2) day2_var_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day2_lin_group2formula(:day2_plan_group2, :day2_actual_group2) day2_lin_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day3_var_group2formula(:day3_plan_group2, :day3_actual_group2) day3_var_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day3_lin_group2formula(:day3_plan_group2, :day3_actual_group2) day3_lin_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day4_var_group2formula(:day4_plan_group2, :day4_actual_group2) day4_var_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day4_lin_group2formula(:day4_plan_group2, :day4_actual_group2) day4_lin_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day5_var_group2formula(:day5_plan_group2, :day5_actual_group2) day5_var_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day5_lin_group2formula(:day5_plan_group2, :day5_actual_group2) day5_lin_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day6_var_group2formula(:day6_plan_group2, :day6_actual_group2) day6_var_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day6_lin_group2formula(:day6_plan_group2, :day6_actual_group2) day6_lin_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day7_var_group2formula(:day7_plan_group2, :day7_actual_group2) day7_var_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day7_lin_group2formula(:day7_plan_group2, :day7_actual_group2) day7_lin_group2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_plan_group2formula(:day1_plan_group2, :day2_plan_group2, :day3_plan_group2, :day4_plan_group2, :day5_plan_group2, :day6_plan_group2, :day7_plan_group2) weekly_plan_group2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_actual_group2formula(:day1_actual_group2, :day2_actual_group2, :day3_actual_group2, :day4_actual_group2, :day5_actual_group2, :day6_actual_group2, :day7_actual_group2) weekly_actual_group2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_var_group2formula(:weekly_plan_group2, :weekly_actual_group2) weekly_var_group2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_lin_group2formula(:weekly_plan_group2, :weekly_actual_group2) weekly_lin_group2, 
	FLM_FLMRFLIN_XMLP_PKG.day1_var_week2formula(:day1_plan_week2, :day1_actual_week2) day1_var_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day1_lin_week2formula(:day1_plan_week2, :day1_actual_week2) day1_lin_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day2_var_week2formula(:day2_plan_week2, :day2_actual_week2) day2_var_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day2_lin_week2formula(:day2_plan_week2, :day2_actual_week2) day2_lin_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day3_var_week2formula(:day3_plan_week2, :day3_actual_week2) day3_var_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day3_lin_week2formula(:day3_plan_week2, :day3_actual_week2) day3_lin_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day4_var_week2formula(:day4_plan_week2, :day4_actual_week2) day4_var_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day4_lin_week2formula(:day4_plan_week2, :day4_actual_week2) day4_lin_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day5_var_week2formula(:day5_plan_week2, :day5_actual_week2) day5_var_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day5_lin_week2formula(:day5_plan_week2, :day5_actual_week2) day5_lin_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day6_var_week2formula(:day6_plan_week2, :day6_actual_week2) day6_var_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day6_lin_week2formula(:day6_plan_week2, :day6_actual_week2) day6_lin_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day7_var_week2formula(:day7_plan_week2, :day7_actual_week2) day7_var_week2, 
	FLM_FLMRFLIN_XMLP_PKG.day7_lin_week2formula(:day7_plan_week2, :day7_actual_week2) day7_lin_week2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_plan_week2formula(:day1_plan_week2, :day2_plan_week2, :day3_plan_week2, :day4_plan_week2, :day5_plan_week2, :day6_plan_week2, :day7_plan_week2) weekly_plan_week2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_actual_week2formula(:day1_actual_week2, :day2_actual_week2, :day3_actual_week2, :day4_actual_week2, :day5_actual_week2, :day6_actual_week2, :day7_actual_week2) weekly_actual_week2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_var_week2formula(:weekly_plan_week2, :weekly_actual_week2) weekly_var_week2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_lin_week2formula(:weekly_plan_week2, :weekly_actual_week2) weekly_lin_week2,*/ 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly_name', 'INV', 'MSTK', 101, MSI1.ORGANIZATION_ID, MSI1.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') assembly_name2, 
	FLM_FLMRFLIN_XMLP_PKG.cf_1formula(number1, number2, number3, number4, number5, number6, number7) weekly_plan2, 
	FLM_FLMRFLIN_XMLP_PKG.weekly_actual2formula(number8, number9, number10, number11, number12, number13, number14) weekly_actual2, 
	--FLM_FLMRFLIN_XMLP_PKG.weekly_var2formula(:weekly_plan2, :weekly_actual2) weekly_var2, 
	--FLM_FLMRFLIN_XMLP_PKG.weekly_lin2formula(:weekly_plan2, :weekly_actual2) weekly_lin2, 
	FLM_FLMRFLIN_XMLP_PKG.day1_lin2formula(number1, number8) day1_lin2, 
	FLM_FLMRFLIN_XMLP_PKG.day2_lin2formula(number2, number9) day2_lin2, 
	FLM_FLMRFLIN_XMLP_PKG.day3_lin2formula(number3, number10) day3_lin2, 
	FLM_FLMRFLIN_XMLP_PKG.day4_lin2formula(number4, number11) day4_lin2, 
	FLM_FLMRFLIN_XMLP_PKG.day5_lin2formula(number5, number12) day5_lin2, 
	FLM_FLMRFLIN_XMLP_PKG.day6_lin2formula(number6, number13) day6_lin2, 
	FLM_FLMRFLIN_XMLP_PKG.day7_lin2formula(number7, number14) day7_lin2
from mrp_form_query mfq, mtl_system_items msi1
where :P_SORT_OPTION = 2
    and query_id = :P_QUERY_ID
    and msi1.inventory_item_id = mfq.number15
    and msi1.organization_id = :P_ORG_ID
Parameter Name SQL text Validation
Organization Id
 
Number
Schedule Group
 
LOV Oracle
To Date
 
LOV Oracle
From Date
 
LOV Oracle
To Line
 
LOV Oracle
From Line
 
LOV Oracle
Sort Option
 
LOV Oracle
Report Option
 
LOV Oracle