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_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 860: msc_supplies s

856: p_action
857: FROM msc_apps_instances mai, -- xml fix
858: msc_system_items msi,
859: msc_trading_partners mp,
860: msc_supplies s
861: WHERE msi.inventory_item_id = s.inventory_item_id
862: AND msi.plan_id = s.plan_id
863: AND msi.organization_id = s.organization_id
864: and msi.sr_instance_id = s.sr_instance_id

Line 921: msc_supplies s

917: p_action
918: FROM msc_apps_instances mai, -- xml fix
919: msc_system_items msi,
920: msc_trading_partners mp,
921: msc_supplies s
922: WHERE msi.inventory_item_id = s.inventory_item_id
923: AND msi.plan_id = s.plan_id
924: AND msi.organization_id = s.organization_id
925: and msi.sr_instance_id = s.sr_instance_id

Line 1029: msc_supplies s

1025: p_po_quantity,
1026: p_plan_id
1027: FROM msc_apps_instances mai,
1028: msc_system_items msi,
1029: msc_supplies s
1030: WHERE msi.inventory_item_id = s.inventory_item_id
1031: AND msi.plan_id = s.plan_id
1032: AND msi.organization_id = s.organization_id
1033: and msi.sr_instance_id = s.sr_instance_id

Line 1087: msc_supplies s

1083: p_po_quantity,
1084: p_plan_id
1085: FROM msc_apps_instances mai,
1086: msc_system_items msi,
1087: msc_supplies s
1088: WHERE msi.inventory_item_id = s.inventory_item_id
1089: AND msi.plan_id = s.plan_id
1090: AND msi.organization_id = s.organization_id
1091: and msi.sr_instance_id = s.sr_instance_id

Line 1177: from msc_supplies

1173: arg_po_res_count(arg_count) := v_temp;
1174:
1175: select count(*)
1176: into v_temp2
1177: from msc_supplies
1178: where plan_id = arg_plan_id
1179: anD release_errors is NULL
1180: and load_type = 20
1181: and order_type = 1

Line 1287: from msc_supplies

1283: arg_po_res_count(arg_count) := v_temp;
1284:
1285: select count(*)
1286: into v_temp2
1287: from msc_supplies
1288: where plan_id = arg_plan_id
1289: AND release_errors is NULL
1290: and load_type = 20
1291: and order_type = 1

Line 1308: UPDATE MSC_SUPPLIES

1304: SELECT release_reschedules
1305: INTO v_autorelease
1306: FROM msc_plans
1307: WHERE plan_id=arg_plan_id;
1308: UPDATE MSC_SUPPLIES
1309: SET implement_date = NULL,
1310: release_status = decode(sign(p_plan_type-100),1,
1311: decode(release_status,11,21,
1312: 12,22,

Line 2122: update msc_supplies

2118: --dbms_output.put_line('item_key='||p_item_key);
2119: wf_engine.StartProcess( itemtype => g_item_type,
2120: itemkey => p_item_key);
2121:
2122: update msc_supplies
2123: SET implement_demand_class = NULL,
2124: implement_date = NULL,
2125: implement_quantity = NULL,
2126: implement_firm = NULL,

Line 2474: from msc_supplies s,

2470: decode(s.order_type, 1, s.disposition_id, null),
2471: s.po_line_id,
2472: s.implement_quantity,
2473: cal2.calendar_date
2474: from msc_supplies s,
2475: msc_system_items msi,
2476: msc_plans mp,
2477: msc_calendar_dates cal1,
2478: msc_calendar_dates cal2,

Line 2502: FROM msc_supplies

2498: AND mtp.partner_type= 3;
2499:
2500: CURSOR need_by_date_cur IS
2501: SELECT new_dock_date
2502: FROM msc_supplies
2503: WHERE plan_id = -1
2504: AND transaction_id = p_transaction_id;
2505:
2506: l_plan_name varchar2(20);