APPS.MSC_GET_BIS_VALUES dependencies on MSC_DEMANDS

Line 1129: ' FROM msc_demands_mv_v mbis'||

1125: ' FROM msc_demand_mv_tab mbis'||
1126: ' WHERE mbis.plan_id = :1 ';
1127: else
1128: sql_statement := ' SELECT count(*) '||
1129: ' FROM msc_demands_mv_v mbis'||
1130: ' WHERE mbis.plan_id = :1 ';
1131: end if;
1132: sql_statement := sql_statement ||
1133: construct_bis_where(false,p_organization_id, p_instance_id,

Line 1407: ' FROM msc_demands_mv_v mbis' ||

1403: p_category_id,p_category_name, p_category_set_id,
1404: p_product_family_id);
1405: ELSIF i =2 THEN
1406: sql_statement := ' SELECT count(*) ' ||
1407: ' FROM msc_demands_mv_v mbis' ||
1408: ' WHERE mbis.plan_id = :1 ' ||
1409: ' AND mbis.using_assembly_demand_date '||
1410: ' BETWEEN :7 AND :8 ';
1411:

Line 2038: ' from msc_demands md '||

2034: if p_date then -- from late_orders
2035: if p_task_id is null then
2036: where_stat := where_stat ||
2037: ' AND exists (select 1 '||
2038: ' from msc_demands md '||
2039: ' where md.plan_id = mbis.plan_id '||
2040: ' and md.demand_id = mbis.number1 '||
2041: ' and md.project_id = :5)';
2042: end if;

Line 2058: ' from msc_demands md '||

2054: if p_task_id is not null then
2055: if p_date then -- from late_orders
2056: where_stat := where_stat ||
2057: ' AND exists (select 1 '||
2058: ' from msc_demands md '||
2059: ' where md.plan_id = mbis.plan_id '||
2060: ' and md.demand_id = mbis.number1 '||
2061: ' and md.project_id = :5 '||
2062: ' and md.task_id = :6)';

Line 2153: ' from msc_demands md '||

2149: if p_start_date is not null then
2150: where_stat := where_stat ||
2151: ' AND exists '||
2152: ' (select 1 '||
2153: ' from msc_demands md '||
2154: ' where md.plan_id = mbis.plan_id '||
2155: ' and md.demand_id = mbis.number1 '||
2156: ' and trunc(nvl(md.assembly_demand_comp_date,md.using_assembly_demand_date)) between :7 and :8)';
2157: g_start_date := trunc(p_start_date);

Line 2270: ' FROM msc_demands md, ' ||

2266: --if (p_use_old_demand_qty is null) then
2267: if v_plan_type <> 4 then
2268: sql_stat := 'SELECT sum(nvl(md.quantity_by_due_date,0)*nvl(md.probability,1)), '||
2269: ' sum(md.USING_REQUIREMENT_QUANTITY*nvl(md.probability,1)) ' ||
2270: ' FROM msc_demands md, ' ||
2271: ' msc_item_categories mic ' ||
2272: where_stat;
2273: --elsif (p_use_old_demand_qty = -1) then
2274: elsif v_plan_type = 4 then

Line 2277: ' FROM msc_demands md, ' ||

2273: --elsif (p_use_old_demand_qty = -1) then
2274: elsif v_plan_type = 4 then
2275: sql_stat := 'SELECT sum(nvl(md.old_demand_quantity,0)*nvl(md.probability,1)), '||
2276: ' sum(md.USING_REQUIREMENT_QUANTITY*nvl(md.probability,1)) ' ||
2277: ' FROM msc_demands md, ' ||
2278: ' msc_item_categories mic ' ||
2279: where_stat;
2280: end if;
2281:

Line 2531: ' FROM msc_demands md, ' ||

2527: v_end := sysdate;
2528: end if;
2529:
2530: sql_stat := 'SELECT avg(md.service_level), count(*) '||
2531: ' FROM msc_demands md, ' ||
2532: ' msc_item_categories mic ' ||
2533: where_stat;
2534: if ( not(from_plan_node) ) then
2535: OPEN the_cursor FOR sql_stat USING p_plan_id,v_org_id,

Line 2581: ' FROM msc_demands ';

2577: v_temp number;
2578: BEGIN
2579:
2580: sql_stat := ' SELECT 1 ' ||
2581: ' FROM msc_demands ';
2582:
2583: where_stat := 'WHERE plan_id = :1 '||
2584: ' AND origination_type in (29) ';
2585: if p_instance_id is not null then

Line 3095: from msc_demands

3091: plan_id,
3092: organization_id,
3093: sr_instance_id,
3094: count(*)
3095: from msc_demands
3096: where origination_type in (6,7,8,9,10,11,12,15,22,24,27,29,30)
3097: and plan_id = p_plan_id
3098: group by plan_id,
3099: organization_id,