FLM Flow Linearity

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