eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_REL_WF dependencies on MSC_DEMANDS

Line 1317: FROM msc_demands md,

1313: p_qty,
1314: p_original_item_id,
1315: p_substitute_item_id,
1316: p_org_id
1317: FROM msc_demands md,
1318: msc_trading_partners mtp
1319: WHERE md.plan_id = arg_plan_id
1320: AND md.release_errors is NULL
1321: and md.load_type = 30

Line 1499: from msc_demands

1495: v_temp2 :=0;
1496:
1497: select count(*)
1498: into v_temp2
1499: from msc_demands
1500: where plan_id = arg_plan_id
1501: anD release_errors is NULL
1502: and load_type = 30
1503: and sr_instance_id = p_inst_id

Line 1513: UPDATE MSC_DEMANDS

1509: end if; -- if v_temp >0 then
1510: END LOOP;
1511: CLOSE instance_cur;
1512:
1513: UPDATE MSC_DEMANDS
1514: SET /* implement_date = NULL,
1515: implement_ship_date = NULL,
1516: implement_earliest_date = NULL,
1517: implement_arrival_date = NULL,

Line 2571: from msc_demands

2567: inventory_item_id,
2568: ship_method,
2569: customer_id,
2570: customer_site_id
2571: from msc_demands
2572: where plan_id = p_plan_id
2573: and demand_id = p_demand_id
2574: and sr_instance_id = p_inst_id;
2575:

Line 2596: from msc_demands md,

2592: md.schedule_ship_date,
2593: nvl(md.planned_ship_date,md.dmd_satisfied_date),
2594: md.planned_arrival_date,
2595: md.intransit_lead_time
2596: from msc_demands md,
2597: msc_system_items msi
2598: where md.plan_id = p_plan_id
2599: and md.ship_set_id = p_ship_set_id
2600: and msi.plan_id = md.plan_id

Line 2624: from msc_demands md,

2620: md.organization_id,
2621: md.sr_instance_id,
2622: nvl(md.planned_ship_date,md.dmd_satisfied_date),
2623: md.planned_arrival_date
2624: from msc_demands md,
2625: msc_system_items msi
2626: where md.plan_id = p_plan_id
2627: and md.arrival_set_id = p_arrival_set_id
2628: and msi.plan_id = md.plan_id

Line 2703: update msc_demands

2699: , p_ship_date);
2700: end if;
2701:
2702: if v_set_demand_id(a) <> p_demand_id then
2703: update msc_demands
2704: set implement_ship_date = p_ship_date, -- sche ship date
2705: implement_date = nvl(implement_date, nvl(firm_date,
2706: nvl(planned_ship_date,dmd_satisfied_date))),
2707: implement_earliest_date = p_earliest_date, -- earliest ship date

Line 2803: update msc_demands

2799: , v_inst_id(a)
2800: , v_lead_time(a)*-1
2801: , p_earliest_date);
2802: if v_set_demand_id(a) <> p_demand_id then
2803: update msc_demands
2804: set implement_arrival_date = p_arrival_date,
2805: implement_earliest_date = v_earliest_date(a),
2806: implement_ship_date = v_ship_date(a), -- sche ship date
2807: implement_date = nvl(implement_date, nvl(firm_date,

Line 2871: update msc_demands

2867: end if;
2868:
2869: end if;
2870: end if; --if so_rec.ship_set_id is null and so_rec.arrival_set_id is null
2871: update msc_demands
2872: set implement_earliest_date = p_earliest_date
2873: where plan_id = p_plan_id
2874: and demand_id = p_demand_id;
2875:

Line 2882: from msc_demands

2878: PROCEDURE unrelease_so_set(p_plan_id number, p_demand_id number,
2879: p_instance_id number) IS
2880: cursor set_id is
2881: select ship_set_id, arrival_set_id
2882: from msc_demands
2883: where plan_id = p_plan_id
2884: and demand_id = p_demand_id
2885: and sr_instance_id = p_instance_id;
2886: p_ship_set_id number;

Line 2894: UPDATE MSC_DEMANDS

2890: FETCH set_id into p_ship_set_id, p_arrival_set_id;
2891: CLOSE set_id;
2892:
2893: if p_ship_set_id is not null then
2894: UPDATE MSC_DEMANDS
2895: SET implement_date = NULL,
2896: implement_ship_date = NULL,
2897: implement_earliest_date = NULL,
2898: implement_arrival_date = NULL,

Line 2914: UPDATE MSC_DEMANDS

2910: AND demand_id <> p_demand_id;
2911: end if;
2912:
2913: if p_arrival_set_id is not null then
2914: UPDATE MSC_DEMANDS
2915: SET implement_date = NULL,
2916: implement_ship_date = NULL,
2917: implement_earliest_date = NULL,
2918: implement_arrival_date = NULL,

Line 2950: from msc_demands

2946: origination_type demand_type,
2947: ship_set_id, arrival_set_id,
2948: decode(nvl(prev_subst_item,0),
2949: inventory_item_id, 0,0,0,1) subst_item
2950: from msc_demands
2951: where plan_id = p_plan_id
2952: and demand_id = p_demand_id
2953: and sr_instance_id = p_inst_id;
2954:

Line 2962: from msc_demands

2958: cursor check_source(p_order_number varchar2,
2959: p_order_type number,
2960: p_org_id number) is
2961: select 1
2962: from msc_demands
2963: where plan_id = p_plan_id
2964: and order_number = p_order_number
2965: and origination_type = p_order_type
2966: and organization_id <> p_org_id

Line 2974: from msc_demands

2970:
2971: cursor check_ship_source(p_ship_set_id number,
2972: p_org_id number) is
2973: select 1
2974: from msc_demands
2975: where plan_id = p_plan_id
2976: and ship_set_id = p_ship_set_id
2977: and organization_id <> p_org_id ;
2978:

Line 2984: from msc_demands

2980:
2981: cursor ship_set(p_ship_set_id number) is
2982: select
2983: decode(nvl(original_item_id,0), inventory_item_id, 0,0,0,1)
2984: from msc_demands
2985: where plan_id = p_plan_id
2986: and ship_set_id = p_ship_set_id;
2987:
2988: cursor arrival_set(p_arrival_set_id number) is

Line 2991: from msc_demands

2987:
2988: cursor arrival_set(p_arrival_set_id number) is
2989: select
2990: decode(nvl(original_item_id,0), inventory_item_id, 0,0,0,1)
2991: from msc_demands
2992: where plan_id = p_plan_id
2993: and arrival_set_id = p_arrival_set_id;
2994:
2995: v_error_msg varchar2(80);

Line 3167: msc_demands md,

3163: md.plan_id,md.original_inst_id)
3164: orig_item_desc
3165: from msc_system_items msi,
3166: msc_plans mp,
3167: msc_demands md,
3168: msc_sales_order_interface msoi
3169: where msoi.batch_id = p_batch_id
3170: and msoi.sr_instance_id = p_instance_id
3171: and msoi.plan_id = md.plan_id