APPS.MSC_REL_WF dependencies on MSC_SUPPLIES

Line 20: FROM msc_supplies s,

16:
17:
18: CURSOR po_res IS
19: SELECT s.transaction_id, s.sr_instance_id
20: FROM msc_supplies s,
21: msc_plan_organizations_v orgs
22: where s.release_errors is NULL
23: AND s.po_line_id is not null
24: AND s.plan_id = orgs.plan_id

Line 41: FROM msc_supplies s,

37: arg_instance);
38:
39: CURSOR req_res IS
40: SELECT s.transaction_id, s.sr_instance_id
41: FROM msc_supplies s,
42: msc_plan_organizations_v orgs
43: where s.release_errors is NULL
44: AND s.plan_id = orgs.plan_id
45: and s.load_type = PURCHASE_REQ_RESCHEDULE

Line 85: from msc_supplies

81: v_instance_code varchar2(5);
82:
83: cursor batch_cur IS
84: SELECT distinct load_type
85: from msc_supplies
86: where plan_id = arg_plan_id
87: and sr_instance_id = v_instance_id
88: and load_type in (WIP_DIS_MASS_LOAD,WIP_REP_MASS_LOAD,
89: LOT_BASED_JOB_LOAD,LOT_BASED_JOB_RESCHEDULE,

Line 258: msc_supplies ms

254: ms.new_order_quantity,
255: msi.buyer_name
256: from msc_plans mp,
257: msc_system_items msi,
258: msc_supplies ms
259: where ms.plan_id = p_plan_id
260: and ms.transaction_id = p_transaction_id
261: and mp.plan_id = ms.plan_id
262: and msi.plan_id = ms.plan_id

Line 393: from msc_supplies ms,

389: poCur PoCurTyp;
390:
391: CURSOR buyer_c IS
392: select mpc.name
393: from msc_supplies ms,
394: msc_system_items msi,
395: msc_partner_contacts mpc
396: where ms.plan_id = p_plan_id
397: and ms.transaction_id = p_transaction_id

Line 408: from msc_supplies ms,

404: and mpc.partner_type =4;
405:
406: CURSOR supplier_c IS
407: select mpc.name
408: from msc_supplies ms,
409: msc_partner_contacts mpc
410: where ms.plan_id = p_plan_id
411: and ms.transaction_id = p_transaction_id
412: and ms.sr_instance_id = mpc.sr_instance_id

Line 426: msc_supplies ms

422: ms.new_schedule_date,
423: ms.implement_date,
424: ms.new_order_quantity
425: from msc_plans mp,
426: msc_supplies ms
427: where ms.plan_id = p_plan_id
428: and ms.transaction_id = p_transaction_id
429: and mp.plan_id = ms.plan_id
430: ;

Line 674: UPDATE MSC_SUPPLIES

670: END DeleteActivities;
671:
672: Procedure reset_load_type (p_plan_id number, p_transaction_id number) IS
673: BEGIN
674: UPDATE MSC_SUPPLIES
675: SET implement_date = NULL,
676: release_status = NULL,
677: load_type = NULL
678: WHERE transaction_id= p_transaction_id

Line 833: msc_supplies s

829: p_action
830: FROM msc_apps_instances mai, -- xml fix
831: msc_system_items msi,
832: msc_trading_partners mp,
833: msc_supplies s
834: WHERE msi.inventory_item_id = s.inventory_item_id
835: AND msi.plan_id = s.plan_id
836: AND msi.organization_id = s.organization_id
837: and msi.sr_instance_id = s.sr_instance_id

Line 939: msc_supplies s

935: p_po_quantity,
936: p_plan_id
937: FROM msc_apps_instances mai,
938: msc_system_items msi,
939: msc_supplies s
940: WHERE msi.inventory_item_id = s.inventory_item_id
941: AND msi.plan_id = s.plan_id
942: AND msi.organization_id = s.organization_id
943: and msi.sr_instance_id = s.sr_instance_id

Line 1027: from msc_supplies

1023: arg_po_res_count(arg_count) := v_temp;
1024:
1025: select count(*)
1026: into v_temp2
1027: from msc_supplies
1028: where plan_id = arg_plan_id
1029: anD release_errors is NULL
1030: and load_type = 20
1031: and order_type = 1

Line 1138: from msc_supplies

1134: arg_po_res_count(arg_count) := v_temp;
1135:
1136: select count(*)
1137: into v_temp2
1138: from msc_supplies
1139: where plan_id = arg_plan_id
1140: AND release_errors is NULL
1141: and load_type = 20
1142: and order_type = 1

Line 1160: UPDATE MSC_SUPPLIES

1156: INTO v_autorelease
1157: FROM msc_plans
1158: WHERE plan_id=arg_plan_id;
1159:
1160: UPDATE MSC_SUPPLIES
1161: SET implement_date = NULL,
1162: release_status = NULL,
1163: load_type = NULL,
1164: applied = decode(v_autorelease,1,applied,2),

Line 1871: update msc_supplies

1867: --dbms_output.put_line('item_key='||p_item_key);
1868: wf_engine.StartProcess( itemtype => g_item_type,
1869: itemkey => p_item_key);
1870:
1871: update msc_supplies
1872: SET implement_demand_class = NULL,
1873: implement_date = NULL,
1874: implement_quantity = NULL,
1875: implement_firm = NULL,

Line 2223: from msc_supplies s,

2219: decode(s.order_type, 1, s.disposition_id, null),
2220: s.po_line_id,
2221: s.implement_quantity,
2222: cal2.calendar_date
2223: from msc_supplies s,
2224: msc_system_items msi,
2225: msc_plans mp,
2226: msc_calendar_dates cal1,
2227: msc_calendar_dates cal2,

Line 2251: FROM msc_supplies

2247: AND mtp.partner_type= 3;
2248:
2249: CURSOR need_by_date_cur IS
2250: SELECT new_dock_date
2251: FROM msc_supplies
2252: WHERE plan_id = -1
2253: AND transaction_id = p_transaction_id;
2254:
2255: l_plan_name varchar2(20);