[Home] [Help]
538: sr_instance_id,
539: organization_id,
540: decode(plan_id, -1, sysdate, trunc(curr_start_date)) curr_start_date,
541: decode(plan_id, -1, sysdate+365, trunc(curr_cutoff_date)) curr_cutoff_date
542: from msc_plans
543: where plan_id = g_plan_id;
544:
545: cursor c_plan_bucket_info_cur is
546: select sum(decode(bucket_type, 1, 1,0)) day_buckets,
564: union all
565: select trunc(curr_start_date)-1,
566: trunc(curr_start_date)-1,
567: -99
568: from msc_plans
569: where plan_id = g_plan_id
570: union all
571: select trunc(curr_cutoff_date)+1,
572: trunc(curr_cutoff_date)+1,
570: union all
571: select trunc(curr_cutoff_date)+1,
572: trunc(curr_cutoff_date)+1,
573: -99
574: from msc_plans
575: where plan_id = g_plan_id
576: order by 1;
577:
578: cursor c_week_start_dates_cur(p_cal_type number, p_cal_code varchar2) is
1436: from
1437: msc_demands md,
1438: msc_analysis_query maq,
1439: msc_form_query mfq2, -- item-list
1440: msc_plans mp,
1441: msc_form_query mfq3 --g_plan_bkts_query_id
1442: where maq.query_id = p_query_id
1443: and maq.region_id = c_global_reg_type
1444: and mfq2.query_id = g_chain_query_id
1549: msc_supplies ms,
1550: msc_analysis_query maq,
1551: msc_form_query mfq1, -- org-list
1552: msc_form_query mfq2, -- item-list
1553: msc_plans mp,
1554: msc_form_query mfq3, --g_plan_bkts_query_id
1555: msc_system_items msi
1556: where maq.query_id = p_query_id
1557: and maq.parent_row_index = g_next_rowset_index
1608: msc_demands md,
1609: msc_analysis_query maq,
1610: msc_form_query mfq1, -- org-list
1611: msc_form_query mfq2, -- item-list
1612: msc_plans mp,
1613: msc_form_query mfq3, --g_plan_bkts_query_id
1614: msc_instance_orgs mio,
1615: msc_system_items msi
1616: where maq.query_id = p_query_id
1829: msc_demands md,
1830: msc_analysis_query maq,
1831: msc_form_query mfq1, -- region-to-org-list
1832: msc_form_query mfq2, -- item-list
1833: msc_plans mp,
1834: msc_form_query mfq3 --g_plan_bkts_query_id
1835: where maq.query_id = p_query_id
1836: and maq.parent_row_index = g_next_rowset_index
1837: and mfq1.query_id = g_org_query_id
1907: msc_demands md,
1908: msc_analysis_query maq,
1909: msc_form_query mfq1, -- region-to-org-list
1910: msc_form_query mfq2, -- item-list
1911: msc_plans mp,
1912: msc_form_query mfq3 --g_plan_bkts_query_id
1913: where maq.query_id = p_query_id
1914: and maq.parent_row_index = g_next_rowset_index
1915: and mfq1.query_id = g_org_query_id
1983: msc_demands md,
1984: msc_analysis_query maq,
1985: msc_form_query mfq1, -- region-to-org-list
1986: msc_form_query mfq2, -- item-list
1987: msc_plans mp,
1988: msc_form_query mfq3 --g_plan_bkts_query_id
1989: where maq.query_id = p_query_id
1990: and maq.parent_row_index = g_next_rowset_index
1991: and mfq1.query_id = g_org_query_id
2039: msc_demands md,
2040: msc_analysis_query maq,
2041: msc_form_query mfq1, -- region-to-org-list
2042: msc_form_query mfq2, -- item-list
2043: msc_plans mp,
2044: msc_forecast_updates mfu,
2045: msc_form_query mfq3 --g_plan_bkts_query_id
2046: where maq.query_id = p_query_id
2047: and maq.parent_row_index = g_next_rowset_index
2098: msc_demands md,
2099: msc_analysis_query maq,
2100: msc_form_query mfq1, -- region-to-org-list
2101: msc_form_query mfq2, -- item-list
2102: msc_plans mp,
2103: msc_forecast_updates mfu,
2104: msc_form_query mfq3 --g_plan_bkts_query_id
2105: where maq.query_id = p_query_id
2106: and maq.parent_row_index = g_next_rowset_index
2155: msc_demands md,
2156: msc_analysis_query maq,
2157: msc_form_query mfq1, -- region-to-org-list
2158: msc_form_query mfq2, -- item-list
2159: msc_plans mp,
2160: msc_forecast_updates mfu,
2161: msc_form_query mfq3 --g_plan_bkts_query_id
2162: where maq.query_id = p_query_id
2163: and maq.parent_row_index = g_next_rowset_index
2224: msc_supplies ms,
2225: msc_analysis_query maq,
2226: msc_form_query mfq1, -- region-to-org-list
2227: msc_form_query mfq2, -- item-list
2228: msc_plans mp,
2229: msc_form_query mfq3, --g_plan_bkts_query_id
2230: msc_system_items msi
2231: where maq.query_id = p_query_id
2232: and maq.parent_row_index = g_next_rowset_index