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_PLAN_PUB dependencies on MSC_SUPPLIES

Line 47: v_batch_id_populated NUMBER := 1; --1 - populated ; 2 - not populated in msc_supplies

43: G_INS_EXCHANGE CONSTANT NUMBER := 5;
44:
45: v_curr_instance_type NUMBER;
46: v_msc_released_only_by_user NUMBER;
47: v_batch_id_populated NUMBER := 1; --1 - populated ; 2 - not populated in msc_supplies
48: v_user_id NUMBER;
49:
50: JOB_CANCELLED CONSTANT INTEGER := 7;
51:

Line 185: from msc_supplies coprod, msc_bom_components mbc

181: BEGIN
182:
183: select sum(coprod.new_order_quantity)
184: into lv_total
185: from msc_supplies coprod, msc_bom_components mbc
186: where coprod.sr_instance_id = inst_id
187: and coprod.plan_id = pln_id
188: and mbc.sr_instance_id = coprod.sr_instance_id
189: and mbc.plan_id = coprod.plan_id

Line 1327: FROM MSC_SUPPLIES s

1323: lv_wf:= SYS_YES;
1324: BEGIN
1325: SELECT load_type
1326: INTO lv_wf_load_type
1327: FROM MSC_SUPPLIES s
1328: WHERE s.plan_id = arg_plan_id
1329: AND s.transaction_id = arg_transaction_id;
1330: EXCEPTION
1331: WHEN NO_DATA_FOUND THEN NULL;

Line 2062: UPDATE MSC_SUPPLIES

2058:
2059:
2060: IF lv_wf= SYS_YES THEN
2061:
2062: UPDATE MSC_SUPPLIES
2063: SET implement_demand_class = NULL,
2064: implement_date = NULL,
2065: implement_quantity = NULL,
2066: implement_firm = NULL,

Line 2098: UPDATE MSC_SUPPLIES

2094: and batch_id = g_batch_id ;
2095:
2096: ELSE
2097:
2098: UPDATE MSC_SUPPLIES
2099: SET implement_demand_class = NULL,
2100: implement_date = NULL,
2101: implement_quantity = NULL,
2102: implement_firm = NULL,

Line 2172: update msc_supplies set batch_id = NULL where batch_id = g_batch_id;

2168: WHERE sr_instance_id= arg_org_instance
2169: and batch_id = g_batch_id;
2170: /*
2171: IF g_batch_id <> -1 THEN
2172: update msc_supplies set batch_id = NULL where batch_id = g_batch_id;
2173: END IF;
2174: */
2175: commit;
2176: raise;

Line 2290: ' s.transaction_id, ' || -- transaction_id of msc_supplies

2286: ' null, ' || -- Sales Order Line ID
2287: ' s.transaction_id, ' || -- Sales Order Number
2288: ' s.implement_unit_number, ' || --end item number
2289: ' DECODE(s.implement_firm, 1, ''Y'',''N''), '||
2290: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2291: l_plan_type ||',' ||
2292: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2293: ' FROM msc_projects mpp, '||
2294: ' msc_trading_partners mp, ' ||

Line 2298: ' msc_supplies s, ' ||

2294: ' msc_trading_partners mp, ' ||
2295: ' msc_trading_partners mp2,' ||
2296: ' msc_system_items msi, ' ||
2297: ' msc_system_items msi1,' ||
2298: ' msc_supplies s, ' ||
2299: ' msc_plan_organizations_v orgs ' ||
2300: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2301: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2302: ' AND mpp.plan_id (+)= s.plan_id ' ||

Line 2420: ' s.transaction_id, ' || -- transaction_id of msc_supplies

2416: ' d.sales_order_line_id,' || -- sales order line_id
2417: ' to_number(substr(d.order_number,1,instr(d.order_number,ltrim(d.order_number,''0123456789''))-1)) ,' || --' msc_rel_plan_pub.Decode_Sales_Order_Number' || l_dblink || '(d.order_number),' || -- xxx dsting
2418: ' s.implement_unit_number, ' || -- end item number
2419: ' DECODE(s.implement_firm, 1, ''Y'', ''N''), '||
2420: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2421: l_plan_type ||','||
2422: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2423: ' FROM msc_projects mpp, '||
2424: ' msc_trading_partners mp, ' ||

Line 2428: ' msc_supplies s,' ||

2424: ' msc_trading_partners mp, ' ||
2425: ' msc_trading_partners mp2,' ||
2426: ' msc_system_items msi, ' ||
2427: ' msc_system_items msi1,' ||
2428: ' msc_supplies s,' ||
2429: ' msc_demands d,' ||
2430: ' msc_plan_organizations_v orgs ' ||
2431: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2432: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||

Line 2502: from msc_supplies ms, msc_single_lvl_peg mslp

2498: END IF;
2499:
2500: update mrp_org_transfer_release motr
2501: set earliest_ship_date = (select max(ms.new_schedule_date)
2502: from msc_supplies ms, msc_single_lvl_peg mslp
2503: where ms.plan_id=l_arg_plan_id
2504: and ms.transaction_id = mslp.child_id
2505: and ms.plan_id= mslp.plan_id
2506: and mslp.parent_id = motr.transaction_id

Line 2526: update msc_supplies

2522:
2523: END IF;
2524:
2525: IF l_arg_mode = 'WF' THEN
2526: update msc_supplies
2527: set releasable = RELEASE_ATTEMPTED
2528: ,batch_id = nvl(batch_id,g_batch_id)
2529: where plan_id = l_arg_plan_id
2530: and transaction_id= l_arg_transaction_id;

Line 2532: execute immediate ' update msc_supplies

2528: ,batch_id = nvl(batch_id,g_batch_id)
2529: where plan_id = l_arg_plan_id
2530: and transaction_id= l_arg_transaction_id;
2531: ELSE
2532: execute immediate ' update msc_supplies
2533: set releasable = ' || RELEASE_ATTEMPTED || '
2534: ,batch_id = nvl(batch_id,' ||g_batch_id ||')
2535: where plan_id = ' || l_arg_plan_id || '
2536: and transaction_id in

Line 2643: ' s.transaction_id, ' || -- transaction_id of msc_supplies

2639: ' null, ' || -- Sales Order Line ID
2640: ' s.transaction_id, ' || -- Sales Order Number
2641: ' s.implement_unit_number, ' || --end item number
2642: ' DECODE(s.implement_firm, 1, ''Y'',''N''), '||
2643: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2644: l_plan_type ||',' ||
2645: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2646: ' FROM msc_projects mpp, ' ||
2647: ' msc_trading_partners mp, ' ||

Line 2735: update msc_supplies

2731: arg_resched_int_reqs := null;
2732:
2733:
2734: IF l_arg_mode = 'WF' THEN
2735: update msc_supplies
2736: set releasable = RELEASE_ATTEMPTED,
2737: batch_id = nvl(batch_id,g_batch_id)
2738: where plan_id = l_arg_plan_id
2739: and transaction_id= l_arg_transaction_id;

Line 2747: execute immediate ' update msc_supplies

2743: batch_id = nvl(batch_id,g_batch_id)
2744: where plan_id = l_arg_plan_id
2745: and transaction_id= l_arg_transaction_id; */
2746: ELSE
2747: execute immediate ' update msc_supplies
2748: set releasable = ' || RELEASE_ATTEMPTED || ',
2749: batch_id = nvl(batch_id,' ||g_batch_id ||')
2750: where plan_id = ' || l_arg_plan_id || '
2751: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in

Line 2864: FROM msc_supplies s,

2860: s1.new_schedule_date promise_date,
2861: s.implement_location_id,
2862: s.Load_Type,
2863: s.implement_source_org_id
2864: FROM msc_supplies s,
2865: msc_supplies s1,
2866: msc_supplies s2,
2867: msc_system_items msi1,
2868: msc_demands d,

Line 2865: msc_supplies s1,

2861: s.implement_location_id,
2862: s.Load_Type,
2863: s.implement_source_org_id
2864: FROM msc_supplies s,
2865: msc_supplies s1,
2866: msc_supplies s2,
2867: msc_system_items msi1,
2868: msc_demands d,
2869: msc_demands d1,

Line 2866: msc_supplies s2,

2862: s.Load_Type,
2863: s.implement_source_org_id
2864: FROM msc_supplies s,
2865: msc_supplies s1,
2866: msc_supplies s2,
2867: msc_system_items msi1,
2868: msc_demands d,
2869: msc_demands d1,
2870: msc_demands d2,

Line 2964: into lv_implement_quantity, lv_release_errors from msc_supplies

2960: );
2961: /* debuf msg
2962: select --implement_quantity,
2963: new_order_quantity, release_errors
2964: into lv_implement_quantity, lv_release_errors from msc_supplies
2965: where plan_id = p_arg_plan_id
2966: and transaction_id = lv_in_req_transaction_id_lst(i);
2967: */
2968:

Line 2969: UPDATE msc_supplies

2965: where plan_id = p_arg_plan_id
2966: and transaction_id = lv_in_req_transaction_id_lst(i);
2967: */
2968:
2969: UPDATE msc_supplies
2970: SET load_type = 32,
2971: release_status = 2,
2972: implement_quantity = new_order_quantity, --to be removed if above api works fine
2973: release_errors = NULL,

Line 3031: update msc_supplies

3027: lv_implement_source_org_id(i);
3028:
3029: p_arg_loaded_int_repair_orders := p_arg_loaded_int_repair_orders + 1 ;
3030:
3031: update msc_supplies
3032: set releasable = RELEASE_ATTEMPTED
3033: ,batch_id = nvl(batch_id,g_batch_id)
3034: where plan_id =p_arg_plan_id
3035: and transaction_id= lv_transaction_id_lst(i);

Line 3073: l_sql_qry := 'UPDATE msc_supplies '

3069: for i IN 1 .. lv_in_req_transaction_id_lst.count LOOP
3070:
3071: If (lv_in_req_transaction_id_lst(i) is NULL) then
3072:
3073: l_sql_qry := 'UPDATE msc_supplies '
3074: ||'SET load_type = NULL
3075: WHERE plan_id= :p_arg_plan_id AND transaction_id = '||lv_out_req_transaction_id_lst(i) ;
3076:
3077: Else

Line 3079: l_sql_qry := 'UPDATE msc_supplies '

3075: WHERE plan_id= :p_arg_plan_id AND transaction_id = '||lv_out_req_transaction_id_lst(i) ;
3076:
3077: Else
3078:
3079: l_sql_qry := 'UPDATE msc_supplies '
3080: ||'SET load_type = NULL WHERE plan_id= :p_arg_plan_id AND transaction_id in ('
3081: || lv_in_req_transaction_id_lst(i)||','||lv_out_req_transaction_id_lst(i)||')' ;
3082: ENd if;
3083:

Line 3092: UPDATE msc_supplies

3088:
3089: END LOOP;
3090: /*
3091: forall i IN 1 .. lv_out_req_transaction_id_lst.count
3092: UPDATE msc_supplies
3093: SET load_type = NULL
3094: WHERE transaction_id = lv_out_req_transaction_id_lst(i)
3095: and plan_id =p_arg_plan_id ;
3096: */

Line 3200: msc_supplies k,

3196: k.Load_Type,
3197: s.implement_source_org_id,
3198: k.transaction_id
3199: FROM
3200: msc_supplies k,
3201: msc_part_supplies s,
3202: msc_part_demands d,
3203: mfg0 mfg,
3204: msc_part_supplies s1,

Line 3283: UPDATE msc_supplies

3279: /* 4.1 iterate through the record in table type and update the load type for transaction_id corresponding to in_req_transaction_id to 32 */
3280: for i IN 1 .. lv_orig_transaction_id_lst.count LOOP
3281:
3282:
3283: UPDATE msc_supplies
3284: SET --load_type = 32,
3285: release_status = 2,
3286: -- implement_quantity = new_order_quantity, --to be removed if above api works fine
3287: --release_errors = NULL,

Line 3360: update msc_supplies -- change the variable name to lv_orig_transaction_id

3356:
3357:
3358: p_arg_loaded_int_repair_orders := p_arg_loaded_int_repair_orders + 1 ;
3359:
3360: update msc_supplies -- change the variable name to lv_orig_transaction_id
3361: set releasable = RELEASE_ATTEMPTED,
3362: batch_id = nvl(batch_id,g_batch_id)
3363: where plan_id = p_arg_plan_id
3364: and transaction_id= lv_orig_transaction_id_lst(i);

Line 3458: FROM msc_supplies s,

3454: nvl(s.implement_dock_date , nvl(s.new_dock_date, sysdate ) ) need_by_date,
3455: s.implement_quantity quantity,
3456: msi1.sr_inventory_item_id defective_item_id,
3457: s2.new_order_quantity defective_part_quantity
3458: FROM msc_supplies s,
3459: Msc_supplies s1,
3460: Msc_supplies s2 ,
3461: msc_system_items msi,
3462: msc_system_items msi1,

Line 3459: Msc_supplies s1,

3455: s.implement_quantity quantity,
3456: msi1.sr_inventory_item_id defective_item_id,
3457: s2.new_order_quantity defective_part_quantity
3458: FROM msc_supplies s,
3459: Msc_supplies s1,
3460: Msc_supplies s2 ,
3461: msc_system_items msi,
3462: msc_system_items msi1,
3463: msc_trading_partners mtp,

Line 3460: Msc_supplies s2 ,

3456: msi1.sr_inventory_item_id defective_item_id,
3457: s2.new_order_quantity defective_part_quantity
3458: FROM msc_supplies s,
3459: Msc_supplies s1,
3460: Msc_supplies s2 ,
3461: msc_system_items msi,
3462: msc_system_items msi1,
3463: msc_trading_partners mtp,
3464: msc_trading_partners mtp1,

Line 3543: update msc_supplies

3539: Execute immediate l_sql_cnt_qry
3540: INTO p_count;
3541:
3542: IF p_arg_mode = 'WF' THEN
3543: update msc_supplies
3544: set releasable = RELEASE_ATTEMPTED
3545: ,batch_id = nvl(batch_id,g_batch_id)
3546: where plan_id = p_arg_plan_id
3547: and transaction_id= p_arg_transaction_id;

Line 3549: execute immediate 'update msc_supplies

3545: ,batch_id = nvl(batch_id,g_batch_id)
3546: where plan_id = p_arg_plan_id
3547: and transaction_id= p_arg_transaction_id;
3548: ELSE
3549: execute immediate 'update msc_supplies
3550: set releasable = ' || RELEASE_ATTEMPTED || '
3551: ,batch_id = nvl(batch_id,' ||g_batch_id || ')
3552: where plan_id = ' || p_arg_plan_id || '
3553: and transaction_id in

Line 3613: msc_supplies k,

3609: s.implement_quantity quantity,
3610: msi1.sr_inventory_item_id defective_item_id,
3611: s2.new_order_quantity defective_part_quantity
3612: FROM
3613: msc_supplies k,
3614: msc_system_items msi,
3615: msc_part_supplies s,
3616: msc_part_demands d,
3617: Msc_part_supplies s1,

Line 3696: update msc_supplies

3692:
3693: p_count := SQL%ROWCOUNT;
3694:
3695: IF p_arg_mode = 'WF' THEN
3696: update msc_supplies
3697: set releasable = RELEASE_ATTEMPTED
3698: ,batch_id = nvl(batch_id,g_batch_id)
3699: where plan_id = p_arg_plan_id
3700: and transaction_id= p_arg_transaction_id;

Line 3708: execute immediate 'update msc_supplies

3704: ,batch_id = g_batch_id
3705: where plan_id = p_arg_plan_id
3706: and orig_transaction_id= p_arg_transaction_id;
3707: ELSE
3708: execute immediate 'update msc_supplies
3709: set releasable = ' || RELEASE_ATTEMPTED || '
3710: ,batch_id = nvl(batch_id,' ||g_batch_id || ')
3711: where plan_id = ' || p_arg_plan_id || '
3712: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in

Line 3811: FROM msc_supplies s,

3807: 2),
3808: 2)),
3809: s.organization_id,
3810: s.plan_id
3811: FROM msc_supplies s,
3812: msc_plan_organizations_v orgs,
3813: msc_plan_buckets mpb,
3814: msc_system_items msi,
3815: msc_plans mp

Line 3864: FROM msc_supplies s,

3860: s.sr_instance_id,
3861: 2 /* Details not enabled for Manual Planned orders */,
3862: s.organization_id,
3863: s.plan_id
3864: FROM msc_supplies s,
3865: msc_plan_organizations_v orgs
3866: WHERE s.release_errors is NULL
3867: AND nvl(s.cfm_routing_flag,0) = 3
3868: AND s.implement_quantity > 0

Line 4058: msc_supplies s

4054: FROM msc_trading_partners tp,
4055: msc_parameters param,
4056: msc_system_items msi,
4057: msc_process_effectivity mpe,
4058: msc_supplies s
4059: WHERE tp.sr_tp_id= msi.organization_id
4060: AND tp.sr_instance_id= msi.sr_instance_id
4061: AND tp.partner_type=3
4062: AND param.organization_id = msi.organization_id

Line 4128: From msc_supplies s,

4124: nwk.from_op_seq_num,
4125: nwk.to_op_seq_num,
4126: 3,
4127: s.sr_instance_id
4128: From msc_supplies s,
4129: msc_operation_networks nwk,
4130: msc_apps_instances ins,
4131: msc_parameters param
4132: Where nwk.plan_id = s.plan_id

Line 4186: From msc_supplies s,

4182: max(res.END_DATE),
4183: 3,
4184: s.sr_instance_id,
4185: max(nvl(res.CUMMULATIVE_QUANTITY,0))
4186: From msc_supplies s,
4187: msc_resource_requirements res,
4188: msc_apps_instances ins,
4189: msc_parameters param
4190: Where res.plan_id = s.plan_id

Line 4286: From msc_supplies s,

4282: ROUND(s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1) ,6),
4283: (s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1))
4284: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
4285: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
4286: From msc_supplies s,
4287: msc_resource_requirements res,
4288: msc_apps_instances ins,
4289: msc_parameters param,
4290: msc_department_resources mdr,

Line 4372: From msc_supplies s,

4368: md.USING_REQUIREMENT_QUANTITY,
4369: md.USING_REQUIREMENT_QUANTITY,
4370: 3,
4371: s.sr_instance_id
4372: From msc_supplies s,
4373: msc_demands md,
4374: msc_system_items icomp,
4375: msc_system_items icomp1,
4376: msc_system_items icomp2,

Line 4469: From msc_supplies s,

4465: -- dsr: add folllowing columns
4466: , res.orig_resource_seq_num
4467: , res.resource_seq_num
4468: , res.parent_seq_num
4469: From msc_supplies s,
4470: msc_resource_requirements res,
4471: msc_apps_instances ins,
4472: msc_parameters param
4473: Where res.plan_id = s.plan_id

Line 4566: msc_supplies s,

4562: msc_trading_partners tp,
4563: msc_resource_requirements resreq,
4564: msc_resource_instance_reqs res_instreq, -- changed from design doc
4565: msc_dept_res_instances dep_res_inst,
4566: msc_supplies s,
4567: msc_apps_instances ins,
4568: msc_parameters param
4569: WHERE
4570: tp.sr_tp_id=s.organization_id

Line 4685: msc_supplies s,

4681: msc_trading_partners tp,
4682: msc_resource_requirements resreq,
4683: msc_resource_instance_reqs res_instreq,
4684: msc_dept_res_instances dep_res_inst,
4685: msc_supplies s,
4686: msc_apps_instances ins,
4687: msc_parameters param
4688: WHERE
4689: tp.sr_tp_id=s.organization_id

Line 4734: update msc_supplies

4730: );
4731:
4732: -- dsr end
4733: FORALL j IN 1..lv_job_count
4734: update msc_supplies
4735: set releasable = RELEASE_ATTEMPTED
4736: ,batch_id = nvl(batch_id,g_batch_id)
4737: where plan_id = arg_plan_id
4738: and transaction_id= lv_transaction_id(j);

Line 4791: msc_supplies s,

4787: 2),2),2)),
4788: s.organization_id,
4789: s.plan_id
4790: FROM msc_plans mp,
4791: msc_supplies s,
4792: msc_plan_organizations_v orgs,
4793: msc_plan_buckets mpb
4794: WHERE mp.plan_id = :arg_plan_id
4795: AND s.release_errors is NULL

Line 4982: msc_supplies s,

4978: , s.requested_completion_date
4979: FROM msc_trading_partners tp,
4980: msc_parameters param,
4981: msc_system_items msi,
4982: msc_supplies s,
4983: msc_plan_organizations_v orgs
4984: WHERE tp.sr_tp_id= msi.organization_id
4985: AND tp.sr_instance_id= msi.sr_instance_id
4986: AND tp.partner_type=3

Line 5059: From msc_supplies s,

5055: decode(nwk.from_op_seq_num, 50000 ,null,nwk.from_op_seq_num),
5056: nwk.to_op_seq_num,
5057: 3,
5058: s.sr_instance_id
5059: From msc_supplies s,
5060: msc_job_operation_networks nwk,
5061: msc_apps_instances ins,
5062: msc_parameters param
5063: Where nwk.plan_id = s.plan_id

Line 5119: From msc_supplies s,

5115: max(res.END_DATE),
5116: 3,
5117: s.sr_instance_id,
5118: max(nvl(res.CUMMULATIVE_QUANTITY,0))
5119: From msc_supplies s,
5120: msc_resource_requirements res,
5121: msc_apps_instances ins,
5122: msc_parameters param
5123: Where res.plan_id = s.plan_id

Line 5224: From msc_supplies s,

5220: ROUND(s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1) ,6),
5221: (s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1))
5222: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
5223: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
5224: From msc_supplies s,
5225: msc_resource_requirements res,
5226: msc_apps_instances ins,
5227: msc_parameters param,
5228: msc_department_resources mdr,

Line 5312: From msc_supplies s,

5308: md.USING_REQUIREMENT_QUANTITY,
5309: md.USING_REQUIREMENT_QUANTITY,
5310: 3,
5311: s.sr_instance_id
5312: From msc_supplies s,
5313: msc_demands md,
5314: msc_system_items icomp,
5315: msc_system_items icomp1,
5316: msc_system_items icomp2,

Line 5410: From msc_supplies s,

5406: -- dsr
5407: res.orig_resource_seq_num,
5408: res.resource_seq_num,
5409: res.parent_seq_num
5410: From msc_supplies s,
5411: msc_resource_requirements res,
5412: msc_apps_instances ins,
5413: msc_parameters param
5414: Where res.plan_id = s.plan_id

Line 5511: msc_supplies s,

5507: FROM msc_trading_partners tp,
5508: msc_resource_requirements resreq,
5509: msc_resource_instance_reqs res_instreq, -- changed from design doc
5510: msc_dept_res_instances dep_res_inst,
5511: msc_supplies s,
5512: msc_apps_instances ins,
5513: msc_parameters param
5514: WHERE
5515: tp.sr_tp_id=s.organization_id

Line 5629: msc_supplies s,

5625: msc_trading_partners tp,
5626: msc_resource_requirements resreq,
5627: msc_resource_instance_reqs res_instreq,
5628: msc_dept_res_instances dep_res_inst,
5629: msc_supplies s,
5630: msc_apps_instances ins,
5631: msc_parameters param
5632: WHERE
5633: tp.sr_tp_id=s.organization_id

Line 5677: update msc_supplies

5673: || sql%rowcount);
5674:
5675:
5676: FORALL j IN 1..lv_resched_jobs
5677: update msc_supplies
5678: set releasable = RELEASE_ATTEMPTED
5679: ,batch_id = nvl(batch_id,g_batch_id)
5680: where plan_id = arg_plan_id
5681: and transaction_id= lv_transaction_id(j);

Line 5722: FROM msc_supplies

5718: CURSOR c_release_dtls(p_transaction_id number,
5719: p_plan_id number) IS
5720: SELECT COUNT(1) FROM (
5721: SELECT count(1)
5722: FROM msc_supplies
5723: WHERE implement_alternate_bom is not null
5724: and transaction_id = p_transaction_id
5725: AND plan_id = p_plan_id
5726: and rownum < 2

Line 5808: FROM msc_supplies s,

5804: 2))),
5805: s.organization_id,
5806: s.plan_id,
5807: decode( ' || l_apps_ver ||' ,4,msi.rounding_control_type,3,msi.rounding_control_type,2)
5808: FROM msc_supplies s,
5809: msc_plan_organizations_v orgs,
5810: msc_plan_buckets mpb,
5811: msc_system_items msi,
5812: msc_plans mp

Line 5861: FROM msc_supplies s,

5857: 2 /* Details not enabled for Manual Planned orders */,
5858: s.organization_id,
5859: s.plan_id,
5860: 2 /* setting rounding control to 2 ,since details are not released and this flag is used in details*/
5861: FROM msc_supplies s,
5862: msc_plan_organizations_v orgs
5863: WHERE s.release_errors is NULL
5864: AND s.implement_quantity > 0
5865: AND s.organization_id = orgs.planned_organization

Line 6086: msc_supplies s

6082: FROM msc_trading_partners tp,
6083: msc_parameters param,
6084: msc_system_items msi,
6085: msc_process_effectivity mpe,
6086: msc_supplies s
6087: WHERE tp.sr_tp_id= msi.organization_id
6088: AND tp.sr_instance_id= msi.sr_instance_id
6089: AND tp.partner_type=3
6090: AND param.organization_id = msi.organization_id

Line 6216: msc_supplies s

6212: FROM msc_trading_partners tp,
6213: msc_resource_requirements resreq,
6214: msc_parameters param,
6215: msc_system_items msi,
6216: msc_supplies s
6217: WHERE tp.sr_tp_id= msi.organization_id
6218: AND tp.sr_instance_id= msi.sr_instance_id
6219: AND tp.partner_type=3
6220: AND resreq.sr_instance_id= s.sr_instance_id

Line 6378: msc_supplies s,

6374: FROM msc_trading_partners tp,
6375: msc_resource_requirements resreq,
6376: msc_parameters param,
6377: msc_system_items msi,
6378: msc_supplies s,
6379: msc_department_resources mdr
6380: WHERE tp.sr_tp_id= msi.organization_id
6381: AND tp.sr_instance_id= msi.sr_instance_id
6382: AND tp.partner_type=3

Line 6499: msc_supplies s

6495: msc_system_items icomp,
6496: msc_demands md,
6497: msc_parameters param,
6498: msc_system_items msi,
6499: msc_supplies s
6500: WHERE /*
6501: ( md.SUBST_ITEM_FLAG <> 1
6502: OR md.SUBST_ITEM_FLAG IS NULL) */
6503: not exists (select 'x'

Line 6601: msc_supplies co,

6597: nvl(s.implement_uom_code,msi.uom_code),
6598: s.sr_instance_id
6599: FROM msc_trading_partners tp,
6600: msc_system_items icomp,
6601: msc_supplies co,
6602: msc_parameters param,
6603: msc_system_items msi,
6604: msc_supplies s
6605: WHERE /* not exists (select 'x'

Line 6604: msc_supplies s

6600: msc_system_items icomp,
6601: msc_supplies co,
6602: msc_parameters param,
6603: msc_system_items msi,
6604: msc_supplies s
6605: WHERE /* not exists (select 'x'
6606: from msc_exception_details excp
6607: where excp.plan_id = msi.plan_id
6608: and excp.number1 = s.transaction_id

Line 6724: msc_supplies s

6720: msc_system_items icomp,
6721: msc_demands md,
6722: msc_parameters param,
6723: msc_system_items msi,
6724: msc_supplies s
6725: WHERE tp.sr_tp_id= msi.organization_id
6726: AND tp.sr_instance_id= msi.sr_instance_id
6727: AND tp.partner_type=3
6728: AND sr_item.inventory_item_id= subcomp.inventory_item_id

Line 6869: msc_supplies s,

6865: FROM msc_trading_partners tp,
6866: msc_resource_requirements resreq,
6867: msc_parameters param,
6868: msc_system_items msi,
6869: msc_supplies s,
6870: msc_department_resources mdr
6871: WHERE tp.sr_tp_id= msi.organization_id
6872: AND tp.sr_instance_id= msi.sr_instance_id
6873: AND tp.partner_type=3

Line 6983: msc_supplies s

6979: msc_trading_partners tp,
6980: msc_resource_requirements resreq,
6981: msc_resource_instance_reqs res_instreq,
6982: msc_dept_res_instances dep_res_inst,
6983: msc_supplies s
6984: WHERE
6985: tp.sr_tp_id=s.organization_id
6986: AND tp.sr_instance_id= s.sr_instance_id
6987: AND tp.partner_type=3

Line 7095: msc_supplies s

7091: msc_trading_partners tp,
7092: msc_resource_requirements resreq,
7093: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
7094: msc_dept_res_instances dep_res_inst,
7095: msc_supplies s
7096: WHERE
7097: tp.sr_tp_id=s.organization_id
7098: AND tp.sr_instance_id= s.sr_instance_id
7099: AND tp.partner_type=3

Line 7191: msc_supplies s,

7187: resreq.resource_seq_num
7188: FROM
7189: msc_trading_partners tp,
7190: msc_resource_requirements resreq,
7191: msc_supplies s,
7192: msc_resource_charges chg
7193: WHERE
7194: tp.sr_tp_id=s.organization_id
7195: AND tp.sr_instance_id= s.sr_instance_id

Line 7217: update msc_supplies

7213: END IF; /* End of l_count = 1 */
7214: -- dsr ends here
7215:
7216: FORALL j IN 1..lv_job_count
7217: update msc_supplies
7218: set releasable = RELEASE_ATTEMPTED
7219: ,batch_id = nvl(batch_id,g_batch_id)
7220: where plan_id = arg_plan_id
7221: and transaction_id= lv_transaction_id(j);

Line 7259: FROM msc_supplies

7255:
7256: CURSOR c_release_dtls(p_transaction_id number,
7257: p_plan_id number) IS
7258: SELECT count(1)
7259: FROM msc_supplies
7260: WHERE implement_alternate_bom is not null
7261: and transaction_id = p_transaction_id
7262: and rownum < 2
7263: UNION

Line 7300: FROM msc_supplies s,

7296: 2),
7297: 2),2)),
7298: s.organization_id,
7299: s.plan_id
7300: FROM msc_supplies s,
7301: msc_plans mp,
7302: msc_plan_organizations_v orgs,
7303: msc_plan_buckets mpb
7304: WHERE s.release_errors is NULL

Line 7493: msc_supplies s,

7489: , s.requested_completion_date -- dsr
7490: FROM msc_trading_partners tp,
7491: msc_parameters param,
7492: msc_system_items msi,
7493: msc_supplies s,
7494: msc_plan_organizations_v orgs
7495: WHERE tp.sr_tp_id= msi.organization_id
7496: AND tp.sr_instance_id= msi.sr_instance_id
7497: AND tp.partner_type=3

Line 7621: msc_supplies s

7617: FROM msc_trading_partners tp,
7618: msc_resource_requirements resreq,
7619: msc_parameters param,
7620: msc_system_items msi,
7621: msc_supplies s
7622: WHERE tp.sr_tp_id= msi.organization_id
7623: AND tp.sr_instance_id= msi.sr_instance_id
7624: AND tp.partner_type=3
7625: AND resreq.sr_instance_id= s.sr_instance_id

Line 7770: msc_supplies s

7766: FROM msc_trading_partners tp,
7767: msc_resource_requirements resreq,
7768: msc_parameters param,
7769: msc_system_items msi,
7770: msc_supplies s
7771: WHERE tp.sr_tp_id= msi.organization_id
7772: AND tp.sr_instance_id= msi.sr_instance_id
7773: AND tp.partner_type=3
7774: AND resreq.sr_instance_id= s.sr_instance_id

Line 7877: msc_supplies s

7873: msc_system_items icomp,
7874: msc_demands md,
7875: msc_parameters param,
7876: msc_system_items msi,
7877: msc_supplies s
7878: WHERE /*
7879: ( md.SUBST_ITEM_FLAG <> 1
7880: OR md.SUBST_ITEM_FLAG IS NULL) */
7881: not exists (select 'x'

Line 7988: msc_supplies co,

7984: s.disposition_id
7985: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
7986: FROM msc_trading_partners tp,
7987: msc_system_items icomp,
7988: msc_supplies co,
7989: msc_parameters param,
7990: msc_system_items msi,
7991: msc_supplies s
7992: WHERE /*not exists (select 'x'

Line 7991: msc_supplies s

7987: msc_system_items icomp,
7988: msc_supplies co,
7989: msc_parameters param,
7990: msc_system_items msi,
7991: msc_supplies s
7992: WHERE /*not exists (select 'x'
7993: from msc_exception_details excp
7994: where excp.plan_id = msi.plan_id
7995: and excp.number1 = s.transaction_id

Line 8118: msc_supplies s

8114: FROM msc_trading_partners tp,
8115: msc_resource_requirements resreq,
8116: msc_parameters param,
8117: msc_system_items msi,
8118: msc_supplies s
8119: WHERE tp.sr_tp_id= msi.organization_id
8120: AND tp.sr_instance_id= msi.sr_instance_id
8121: AND tp.partner_type=3
8122: AND resreq.sr_instance_id= s.sr_instance_id

Line 8226: msc_supplies s

8222: msc_trading_partners tp,
8223: msc_resource_requirements resreq,
8224: msc_resource_instance_reqs res_instreq,
8225: msc_dept_res_instances dep_res_inst,
8226: msc_supplies s
8227: WHERE
8228: tp.sr_tp_id=s.organization_id
8229: AND tp.sr_instance_id= s.sr_instance_id
8230: AND tp.partner_type=3

Line 8344: msc_supplies s

8340: msc_trading_partners tp,
8341: msc_resource_requirements resreq,
8342: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
8343: msc_dept_res_instances dep_res_inst,
8344: msc_supplies s
8345: WHERE
8346: tp.sr_tp_id=s.organization_id
8347: AND tp.sr_instance_id= s.sr_instance_id
8348: AND tp.partner_type=3

Line 8446: msc_supplies s,

8442: , resreq.resource_seq_num
8443: FROM
8444: msc_trading_partners tp,
8445: msc_resource_requirements resreq,
8446: msc_supplies s,
8447: msc_resource_charges chg
8448: WHERE
8449: tp.sr_tp_id=s.organization_id
8450: AND tp.sr_instance_id= s.sr_instance_id

Line 8475: update msc_supplies

8471: -- dsr ends here
8472: END IF; /* End of l_count = 1 */
8473:
8474: FORALL j IN 1..lv_job_count
8475: update msc_supplies
8476: set releasable = RELEASE_ATTEMPTED
8477: ,batch_id = nvl(batch_id,g_batch_id)
8478: where plan_id = arg_plan_id
8479: and transaction_id= lv_transaction_id(j);

Line 8569: msc_supplies s,

8565: FROM msc_trading_partners tp,
8566: msc_parameters param,
8567: msc_system_items msi,
8568: msc_process_effectivity mpe,
8569: msc_supplies s,
8570: msc_plan_organizations_v orgs
8571: WHERE tp.sr_tp_id= msi.organization_id
8572: AND tp.sr_instance_id= msi.sr_instance_id
8573: AND tp.partner_type=3

Line 8628: update msc_supplies

8624: END IF;
8625:
8626:
8627: IF arg_mode = 'WF' THEN
8628: update msc_supplies
8629: set releasable = RELEASE_ATTEMPTED
8630: ,batch_id = nvl(batch_id,g_batch_id)
8631: where plan_id = arg_plan_id
8632: and transaction_id= arg_transaction_id;

Line 8634: update msc_supplies

8630: ,batch_id = nvl(batch_id,g_batch_id)
8631: where plan_id = arg_plan_id
8632: and transaction_id= arg_transaction_id;
8633: ELSE
8634: update msc_supplies
8635: set releasable = RELEASE_ATTEMPTED
8636: ,batch_id = nvl(batch_id,g_batch_id)
8637: where plan_id = arg_plan_id
8638: and transaction_id in (select source_line_id from msc_wip_job_schedule_interface

Line 8768: in msc_supplies so we can safely use mp1 for both cases.

8764: s.organization_id,
8765: 'P',
8766: mp.operating_unit,
8767: /* for single instance if the organization is modelled then the source_sr_instane_id = sr_instance_id
8768: in msc_supplies so we can safely use mp1 for both cases.
8769: For cross-instance releases get the modeled supplier infor */
8770: decode(s.implement_source_org_id, NULL, to_number(NULL),
8771: decode(mp1.MODELED_SUPPLIER_ID, NULL,s.implement_source_org_id, to_number(NULL) ) ),
8772: decode(s.implement_source_org_id, NULL ,supplier.sr_tp_id,

Line 8796: msc_supplies s,

8792: msc_trading_partners mp, -- mtl_parameters mp,
8793: msc_trading_partners mp1,
8794: msc_system_items msi,
8795: msc_system_items msi1,
8796: msc_supplies s,
8797: msc_item_suppliers mis,
8798: msc_plan_organizations_v orgs
8799: WHERE supplier.tp_id(+)=
8800: nvl(s.implement_supplier_id, s.source_supplier_id)

Line 8940: msc_supplies s,

8936: msc_trading_partners mp1,
8937: msc_system_items msi,
8938: msc_system_items msi1,
8939: msc_item_suppliers mis,
8940: msc_supplies s,
8941: msc_plan_organizations_v orgs
8942: WHERE supplier.tp_id(+)=
8943: nvl(s.implement_supplier_id, s.source_supplier_id)
8944: AND supplier.partner_type(+)=1

Line 9082: msc_supplies s,

9078: msc_trading_partners mp1,
9079: msc_system_items msi,
9080: msc_system_items msi1,
9081: msc_item_suppliers mis,
9082: msc_supplies s,
9083: msc_plan_organizations_v orgs
9084: WHERE supplier.tp_id(+)=
9085: nvl(s.implement_supplier_id, s.source_supplier_id)
9086: AND supplier.partner_type(+)=1

Line 9162: update msc_supplies

9158: raise lv_custom;
9159: END IF;
9160:
9161: IF arg_mode = 'WF' THEN
9162: update msc_supplies
9163: set releasable = RELEASE_ATTEMPTED
9164: ,batch_id = nvl(batch_id,g_batch_id)
9165: where plan_id = arg_plan_id
9166: and transaction_id= arg_transaction_id;

Line 9168: update msc_supplies

9164: ,batch_id = nvl(batch_id,g_batch_id)
9165: where plan_id = arg_plan_id
9166: and transaction_id= arg_transaction_id;
9167: ELSE
9168: update msc_supplies
9169: set releasable = RELEASE_ATTEMPTED
9170: ,batch_id = nvl(batch_id,g_batch_id)
9171: where plan_id = arg_plan_id
9172: and transaction_id in (select source_line_id from msc_po_requisitions_interface

Line 9232: msc_supplies s,

9228: FROM --msc_calendar_dates cal1,
9229: --msc_calendar_dates cal2,
9230: msc_trading_partners mp,
9231: msc_system_items msi,
9232: msc_supplies s,
9233: msc_apps_instances mai, -- IR/ISO resch Proj
9234: msc_plan_organizations_v orgs
9235: WHERE --cal1.sr_instance_id= mp.sr_instance_id
9236: --AND cal1.calendar_code = mp.calendar_code

Line 9291: msc_supplies s,

9287: FROM --msc_calendar_dates cal1,
9288: --msc_calendar_dates cal2,
9289: msc_trading_partners mp,
9290: msc_system_items msi,
9291: msc_supplies s,
9292: msc_plan_organizations_v orgs
9293: WHERE --cal1.sr_instance_id= mp.sr_instance_id
9294: --AND cal1.calendar_code = mp.calendar_code
9295: -- AND cal1.exception_set_id = mp.calendar_exception_set_id

Line 9331: update msc_supplies

9327: lv_resched_reqs := 0;
9328: END IF;
9329:
9330: IF arg_mode = 'WF' THEN
9331: update msc_supplies
9332: set releasable = RELEASE_ATTEMPTED
9333: ,batch_id = nvl(batch_id,g_batch_id)
9334: where plan_id = arg_plan_id
9335: and transaction_id= arg_transaction_id;

Line 9338: update msc_supplies

9334: where plan_id = arg_plan_id
9335: and transaction_id= arg_transaction_id;
9336: ELSE
9337: IF v_batch_id_populated = 1 THEN
9338: update msc_supplies
9339: set releasable = RELEASE_ATTEMPTED
9340: where batch_id = g_batch_id;
9341: ELSE
9342: update msc_supplies

Line 9342: update msc_supplies

9338: update msc_supplies
9339: set releasable = RELEASE_ATTEMPTED
9340: where batch_id = g_batch_id;
9341: ELSE
9342: update msc_supplies
9343: set releasable = RELEASE_ATTEMPTED
9344: ,batch_id = g_batch_id
9345: where plan_id = arg_plan_id
9346: and transaction_id in (select source_line_id from msc_po_reschedule_interface);

Line 9400: msc_supplies s,

9396: FROM --msc_calendar_dates cal1,
9397: --msc_calendar_dates cal2,
9398: msc_trading_partners mp,
9399: msc_system_items msi,
9400: msc_supplies s,
9401: msc_plan_organizations_v orgs
9402: WHERE --cal1.sr_instance_id = mp.sr_instance_id
9403: --AND cal1.calendar_code = mp.calendar_code
9404: --AND cal1.exception_set_id = mp.calendar_exception_set_id

Line 9464: update msc_supplies

9460: IN lv_po_number,
9461: OUT lv_return_code;
9462: END IF;
9463:
9464: update msc_supplies
9465: set releasable = RELEASE_ATTEMPTED
9466: ,batch_id = nvl(batch_id,g_batch_id)
9467: where plan_id = arg_plan_id
9468: and transaction_id= arg_transaction_id;