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 2027: ' from msc_demands md '||

2023: if p_date then -- from late_orders
2024: if p_task_id is null then
2025: where_stat := where_stat ||
2026: ' AND exists (select 1 '||
2027: ' from msc_demands md '||
2028: ' where md.plan_id = mbis.plan_id '||
2029: ' and md.demand_id = mbis.number1 '||
2030: ' and md.project_id = :5)';
2031: end if;

Line 2047: ' from msc_demands md '||

2043: if p_task_id is not null then
2044: if p_date then -- from late_orders
2045: where_stat := where_stat ||
2046: ' AND exists (select 1 '||
2047: ' from msc_demands md '||
2048: ' where md.plan_id = mbis.plan_id '||
2049: ' and md.demand_id = mbis.number1 '||
2050: ' and md.project_id = :5 '||
2051: ' and md.task_id = :6)';

Line 2142: ' from msc_demands md '||

2138: if p_start_date is not null then
2139: where_stat := where_stat ||
2140: ' AND exists '||
2141: ' (select 1 '||
2142: ' from msc_demands md '||
2143: ' where md.plan_id = mbis.plan_id '||
2144: ' and md.demand_id = mbis.number1 '||
2145: ' and trunc(nvl(md.assembly_demand_comp_date,md.using_assembly_demand_date)) between :7 and :8)';
2146: g_start_date := trunc(p_start_date);

Line 2259: ' FROM msc_demands md, ' ||

2255: --if (p_use_old_demand_qty is null) then
2256: if v_plan_type <> 4 then
2257: sql_stat := 'SELECT sum(nvl(md.quantity_by_due_date,0)*nvl(md.probability,1)), '||
2258: ' sum(md.USING_REQUIREMENT_QUANTITY*nvl(md.probability,1)) ' ||
2259: ' FROM msc_demands md, ' ||
2260: ' msc_item_categories mic ' ||
2261: where_stat;
2262: --elsif (p_use_old_demand_qty = -1) then
2263: elsif v_plan_type = 4 then

Line 2266: ' FROM msc_demands md, ' ||

2262: --elsif (p_use_old_demand_qty = -1) then
2263: elsif v_plan_type = 4 then
2264: sql_stat := 'SELECT sum(nvl(md.old_demand_quantity,0)*nvl(md.probability,1)), '||
2265: ' sum(md.USING_REQUIREMENT_QUANTITY*nvl(md.probability,1)) ' ||
2266: ' FROM msc_demands md, ' ||
2267: ' msc_item_categories mic ' ||
2268: where_stat;
2269: end if;
2270:

Line 2520: ' FROM msc_demands md, ' ||

2516: v_end := sysdate;
2517: end if;
2518:
2519: sql_stat := 'SELECT avg(md.service_level), count(*) '||
2520: ' FROM msc_demands md, ' ||
2521: ' msc_item_categories mic ' ||
2522: where_stat;
2523: if ( not(from_plan_node) ) then
2524: OPEN the_cursor FOR sql_stat USING p_plan_id,v_org_id,

Line 2570: ' FROM msc_demands ';

2566: v_temp number;
2567: BEGIN
2568:
2569: sql_stat := ' SELECT 1 ' ||
2570: ' FROM msc_demands ';
2571:
2572: where_stat := 'WHERE plan_id = :1 '||
2573: ' AND origination_type in (29) ';
2574: if p_instance_id is not null then

Line 3084: from msc_demands

3080: plan_id,
3081: organization_id,
3082: sr_instance_id,
3083: count(*)
3084: from msc_demands
3085: where origination_type in (6,7,8,9,10,11,12,15,22,24,27,29,30)
3086: and plan_id = p_plan_id
3087: group by plan_id,
3088: organization_id,