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 48: v_batch_id_populated NUMBER := 1; --1 - populated ; 2 - not populated in msc_supplies

44:
45: gv_auto_release NUMBER;
46: v_curr_instance_type NUMBER;
47: v_msc_released_only_by_user NUMBER;
48: v_batch_id_populated NUMBER := 1; --1 - populated ; 2 - not populated in msc_supplies
49: v_plan_type NUMBER; -- For RP Release
50: v_rp_plan NUMBER := 0 ;
51: v_user_id NUMBER;
52: v_time_stamp NUMBER := 0;

Line 193: from msc_supplies coprod, msc_bom_components mbc

189: BEGIN
190:
191: select sum(coprod.new_order_quantity)
192: into lv_total
193: from msc_supplies coprod, msc_bom_components mbc
194: where coprod.sr_instance_id = inst_id
195: and coprod.plan_id = pln_id
196: and mbc.sr_instance_id = coprod.sr_instance_id
197: and mbc.plan_id = coprod.plan_id

Line 1499: FROM msc_supplies s, msc_plans p

1495: 11,21,
1496: 12,22,
1497: 13,23,
1498: s.release_status) rp_release_status
1499: FROM msc_supplies s, msc_plans p
1500: WHERE p.plan_id = s.plan_id
1501: AND s.plan_id = arg_plan_id
1502: AND batch_id = g_batch_id;
1503:

Line 1613: FROM MSC_SUPPLIES s

1609: lv_wf:= SYS_YES;
1610: BEGIN
1611: SELECT load_type
1612: INTO lv_wf_load_type
1613: FROM MSC_SUPPLIES s
1614: WHERE s.plan_id = arg_plan_id
1615: AND s.transaction_id = arg_transaction_id;
1616: EXCEPTION
1617: WHEN NO_DATA_FOUND THEN NULL;

Line 2575: UPDATE MSC_SUPPLIES

2571: END;
2572: END IF;
2573: IF lv_wf= SYS_YES THEN
2574:
2575: UPDATE MSC_SUPPLIES
2576: SET implement_demand_class = NULL,
2577: implement_date = NULL,
2578: implement_quantity = NULL,
2579: implement_firm = NULL,

Line 2616: UPDATE MSC_SUPPLIES

2612: and batch_id = g_batch_id ;
2613:
2614: ELSE
2615:
2616: UPDATE MSC_SUPPLIES
2617: SET implement_demand_class = NULL,
2618: implement_date = NULL,
2619: implement_quantity = NULL,
2620: implement_firm = NULL,

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

2701: WHERE sr_instance_id= arg_org_instance
2702: and batch_id = g_batch_id;
2703: /*
2704: IF g_batch_id <> -1 THEN
2705: update msc_supplies set batch_id = NULL where batch_id = g_batch_id;
2706: END IF;
2707: */
2708: commit;
2709: raise;

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

2820: ' null, ' || -- Sales Order Line ID
2821: ' s.transaction_id, ' || -- Sales Order Number
2822: ' s.implement_unit_number, ' || --end item number
2823: ' DECODE(s.implement_firm, 1, ''Y'',''N''), '||
2824: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2825: l_plan_type ||',' ||
2826: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
2827: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2828: ' FROM msc_projects mpp, '||

Line 2826: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352

2822: ' s.implement_unit_number, ' || --end item number
2823: ' DECODE(s.implement_firm, 1, ''Y'',''N''), '||
2824: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2825: l_plan_type ||',' ||
2826: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
2827: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2828: ' FROM msc_projects mpp, '||
2829: ' msc_trading_partners mp, ' ||
2830: ' msc_trading_partners mp2,' ||

Line 2833: ' msc_supplies s, ' ||

2829: ' msc_trading_partners mp, ' ||
2830: ' msc_trading_partners mp2,' ||
2831: ' msc_system_items msi, ' ||
2832: ' msc_system_items msi1,' ||
2833: ' msc_supplies s, ' ||
2834: ' msc_plan_organizations_v orgs ' ||
2835: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2836: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2837: ' AND mpp.plan_id (+)= s.plan_id ' ||

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

2952: /* ' 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 */
2953: ' decode(instr(d.order_number,ltrim(d.order_number,''0123456789'')), null,to_number(d.order_number), to_number(substr(d.order_number,1,instr(d.order_number,ltrim(d.order_number,''0123456789''))-1))), '|| -- 9849059
2954: ' s.implement_unit_number, ' || -- end item number
2955: ' DECODE(s.implement_firm, 1, ''Y'', ''N''), '||
2956: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2957: l_plan_type ||','||
2958: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2959: ' FROM msc_projects mpp, '||
2960: ' msc_trading_partners mp, ' ||

Line 2964: ' msc_supplies s,' ||

2960: ' msc_trading_partners mp, ' ||
2961: ' msc_trading_partners mp2,' ||
2962: ' msc_system_items msi, ' ||
2963: ' msc_system_items msi1,' ||
2964: ' msc_supplies s,' ||
2965: ' msc_demands d,' ||
2966: ' msc_plan_organizations_v orgs ' ||
2967: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2968: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||

Line 3040: from msc_supplies ms, msc_single_lvl_peg mslp

3036: END IF;
3037:
3038: update mrp_org_transfer_release motr
3039: set earliest_ship_date = (select max(ms.new_schedule_date)
3040: from msc_supplies ms, msc_single_lvl_peg mslp
3041: where ms.plan_id=l_arg_plan_id
3042: and ms.transaction_id = mslp.child_id
3043: and ms.plan_id= mslp.plan_id
3044: and mslp.parent_id = motr.transaction_id

Line 3064: update msc_supplies

3060:
3061: END IF;
3062:
3063: IF l_arg_mode = 'WF' THEN
3064: update msc_supplies
3065: set releasable = RELEASE_ATTEMPTED
3066: ,batch_id = nvl(batch_id,g_batch_id)
3067: where plan_id = l_arg_plan_id
3068: and transaction_id= l_arg_transaction_id;

Line 3070: execute immediate ' update msc_supplies

3066: ,batch_id = nvl(batch_id,g_batch_id)
3067: where plan_id = l_arg_plan_id
3068: and transaction_id= l_arg_transaction_id;
3069: ELSE
3070: execute immediate ' update msc_supplies
3071: set releasable = ' || RELEASE_ATTEMPTED || '
3072: ,batch_id = nvl(batch_id,' ||g_batch_id ||')
3073: where plan_id = ' || l_arg_plan_id || '
3074: and transaction_id in

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

3178: ' null, ' || -- Sales Order Line ID
3179: ' s.transaction_id, ' || -- Sales Order Number
3180: ' s.implement_unit_number, ' || --end item number
3181: ' DECODE(s.implement_firm, 1, ''Y'',''N''), '||
3182: ' s.transaction_id, ' || -- transaction_id of msc_supplies
3183: l_plan_type ||',' ||
3184: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
3185: ' nvl(s.implement_ship_method,s.ship_method) ' ||
3186: ' FROM msc_projects mpp, ' ||

Line 3184: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352

3180: ' s.implement_unit_number, ' || --end item number
3181: ' DECODE(s.implement_firm, 1, ''Y'',''N''), '||
3182: ' s.transaction_id, ' || -- transaction_id of msc_supplies
3183: l_plan_type ||',' ||
3184: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
3185: ' nvl(s.implement_ship_method,s.ship_method) ' ||
3186: ' FROM msc_projects mpp, ' ||
3187: ' msc_trading_partners mp, ' ||
3188: ' msc_trading_partners mp2, ' ||

Line 3275: update msc_supplies

3271: arg_resched_int_reqs := null;
3272:
3273:
3274: IF l_arg_mode = 'WF' THEN
3275: update msc_supplies
3276: set releasable = RELEASE_ATTEMPTED,
3277: batch_id = nvl(batch_id,g_batch_id)
3278: where plan_id = l_arg_plan_id
3279: and transaction_id= l_arg_transaction_id;

Line 3287: execute immediate ' update msc_supplies

3283: batch_id = nvl(batch_id,g_batch_id)
3284: where plan_id = l_arg_plan_id
3285: and transaction_id= l_arg_transaction_id; */
3286: ELSE
3287: execute immediate ' update msc_supplies
3288: set releasable = ' || RELEASE_ATTEMPTED || ',
3289: batch_id = nvl(batch_id,' ||g_batch_id ||')
3290: where plan_id = ' || l_arg_plan_id || '
3291: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in

Line 3404: FROM msc_supplies s,

3400: s1.new_schedule_date promise_date,
3401: s.implement_location_id,
3402: s.Load_Type,
3403: s.implement_source_org_id
3404: FROM msc_supplies s,
3405: msc_supplies s1,
3406: msc_supplies s2,
3407: msc_system_items msi1,
3408: msc_demands d,

Line 3405: msc_supplies s1,

3401: s.implement_location_id,
3402: s.Load_Type,
3403: s.implement_source_org_id
3404: FROM msc_supplies s,
3405: msc_supplies s1,
3406: msc_supplies s2,
3407: msc_system_items msi1,
3408: msc_demands d,
3409: msc_demands d1,

Line 3406: msc_supplies s2,

3402: s.Load_Type,
3403: s.implement_source_org_id
3404: FROM msc_supplies s,
3405: msc_supplies s1,
3406: msc_supplies s2,
3407: msc_system_items msi1,
3408: msc_demands d,
3409: msc_demands d1,
3410: msc_demands d2,

Line 3504: into lv_implement_quantity, lv_release_errors from msc_supplies

3500: );
3501: /* debuf msg
3502: select --implement_quantity,
3503: new_order_quantity, release_errors
3504: into lv_implement_quantity, lv_release_errors from msc_supplies
3505: where plan_id = p_arg_plan_id
3506: and transaction_id = lv_in_req_transaction_id_lst(i);
3507: */
3508:

Line 3509: UPDATE msc_supplies

3505: where plan_id = p_arg_plan_id
3506: and transaction_id = lv_in_req_transaction_id_lst(i);
3507: */
3508:
3509: UPDATE msc_supplies
3510: SET load_type = 32,
3511: release_status = 2,
3512: implement_quantity = new_order_quantity, --to be removed if above api works fine
3513: release_errors = NULL,

Line 3571: update msc_supplies

3567: lv_implement_source_org_id(i);
3568:
3569: p_arg_loaded_int_repair_orders := p_arg_loaded_int_repair_orders + 1 ;
3570:
3571: update msc_supplies
3572: set releasable = RELEASE_ATTEMPTED
3573: ,batch_id = nvl(batch_id,g_batch_id)
3574: where plan_id =p_arg_plan_id
3575: and transaction_id= lv_transaction_id_lst(i);

Line 3613: l_sql_qry := 'UPDATE msc_supplies '

3609: for i IN 1 .. lv_in_req_transaction_id_lst.count LOOP
3610:
3611: If (lv_in_req_transaction_id_lst(i) is NULL) then
3612:
3613: l_sql_qry := 'UPDATE msc_supplies '
3614: ||'SET load_type = NULL
3615: WHERE plan_id= :p_arg_plan_id AND transaction_id = '||lv_out_req_transaction_id_lst(i) ;
3616:
3617: Else

Line 3619: l_sql_qry := 'UPDATE msc_supplies '

3615: WHERE plan_id= :p_arg_plan_id AND transaction_id = '||lv_out_req_transaction_id_lst(i) ;
3616:
3617: Else
3618:
3619: l_sql_qry := 'UPDATE msc_supplies '
3620: ||'SET load_type = NULL WHERE plan_id= :p_arg_plan_id AND transaction_id in ('
3621: || lv_in_req_transaction_id_lst(i)||','||lv_out_req_transaction_id_lst(i)||')' ;
3622: ENd if;
3623:

Line 3632: UPDATE msc_supplies

3628:
3629: END LOOP;
3630: /*
3631: forall i IN 1 .. lv_out_req_transaction_id_lst.count
3632: UPDATE msc_supplies
3633: SET load_type = NULL
3634: WHERE transaction_id = lv_out_req_transaction_id_lst(i)
3635: and plan_id =p_arg_plan_id ;
3636: */

Line 3740: msc_supplies k,

3736: k.Load_Type,
3737: s.implement_source_org_id,
3738: k.transaction_id
3739: FROM
3740: msc_supplies k,
3741: msc_part_supplies s,
3742: msc_part_demands d,
3743: mfg0 mfg,
3744: msc_part_supplies s1,

Line 3823: UPDATE msc_supplies

3819: /* 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 */
3820: for i IN 1 .. lv_orig_transaction_id_lst.count LOOP
3821:
3822:
3823: UPDATE msc_supplies
3824: SET --load_type = 32,
3825: release_status = 2,
3826: -- implement_quantity = new_order_quantity, --to be removed if above api works fine
3827: --release_errors = NULL,

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

3896:
3897:
3898: p_arg_loaded_int_repair_orders := p_arg_loaded_int_repair_orders + 1 ;
3899:
3900: update msc_supplies -- change the variable name to lv_orig_transaction_id
3901: set releasable = RELEASE_ATTEMPTED,
3902: batch_id = nvl(batch_id,g_batch_id)
3903: where plan_id = p_arg_plan_id
3904: and transaction_id= lv_orig_transaction_id_lst(i);

Line 3998: FROM msc_supplies s,

3994: nvl(s.implement_dock_date , nvl(s.new_dock_date, sysdate ) ) need_by_date,
3995: s.implement_quantity quantity,
3996: msi1.sr_inventory_item_id defective_item_id,
3997: s2.new_order_quantity defective_part_quantity
3998: FROM msc_supplies s,
3999: Msc_supplies s1,
4000: Msc_supplies s2 ,
4001: msc_system_items msi,
4002: msc_system_items msi1,

Line 3999: Msc_supplies s1,

3995: s.implement_quantity quantity,
3996: msi1.sr_inventory_item_id defective_item_id,
3997: s2.new_order_quantity defective_part_quantity
3998: FROM msc_supplies s,
3999: Msc_supplies s1,
4000: Msc_supplies s2 ,
4001: msc_system_items msi,
4002: msc_system_items msi1,
4003: msc_trading_partners mtp,

Line 4000: Msc_supplies s2 ,

3996: msi1.sr_inventory_item_id defective_item_id,
3997: s2.new_order_quantity defective_part_quantity
3998: FROM msc_supplies s,
3999: Msc_supplies s1,
4000: Msc_supplies s2 ,
4001: msc_system_items msi,
4002: msc_system_items msi1,
4003: msc_trading_partners mtp,
4004: msc_trading_partners mtp1,

Line 4084: update msc_supplies

4080: Execute immediate l_sql_cnt_qry
4081: INTO p_count;
4082:
4083: IF p_arg_mode = 'WF' THEN
4084: update msc_supplies
4085: set releasable = RELEASE_ATTEMPTED
4086: ,batch_id = nvl(batch_id,g_batch_id)
4087: where plan_id = p_arg_plan_id
4088: and transaction_id= p_arg_transaction_id;

Line 4090: execute immediate 'update msc_supplies

4086: ,batch_id = nvl(batch_id,g_batch_id)
4087: where plan_id = p_arg_plan_id
4088: and transaction_id= p_arg_transaction_id;
4089: ELSE
4090: execute immediate 'update msc_supplies
4091: set releasable = ' || RELEASE_ATTEMPTED || '
4092: ,batch_id = nvl(batch_id,' ||g_batch_id || ')
4093: where plan_id = ' || p_arg_plan_id || '
4094: and transaction_id in

Line 4154: msc_supplies k,

4150: s.implement_quantity quantity,
4151: msi1.sr_inventory_item_id defective_item_id,
4152: s2.new_order_quantity defective_part_quantity
4153: FROM
4154: msc_supplies k,
4155: msc_system_items msi,
4156: msc_part_supplies s,
4157: msc_part_demands d,
4158: Msc_part_supplies s1,

Line 4238: update msc_supplies

4234:
4235: p_count := SQL%ROWCOUNT;
4236:
4237: IF p_arg_mode = 'WF' THEN
4238: update msc_supplies
4239: set releasable = RELEASE_ATTEMPTED
4240: ,batch_id = nvl(batch_id,g_batch_id)
4241: where plan_id = p_arg_plan_id
4242: and transaction_id= p_arg_transaction_id;

Line 4250: execute immediate 'update msc_supplies

4246: ,batch_id = g_batch_id
4247: where plan_id = p_arg_plan_id
4248: and orig_transaction_id= p_arg_transaction_id;
4249: ELSE
4250: execute immediate 'update msc_supplies
4251: set releasable = ' || RELEASE_ATTEMPTED || '
4252: ,batch_id = nvl(batch_id,' ||g_batch_id || ')
4253: where plan_id = ' || p_arg_plan_id || '
4254: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in

Line 4360: FROM msc_supplies s,

4356: 2),
4357: 2)),
4358: s.organization_id,
4359: s.plan_id
4360: FROM msc_supplies s,
4361: msc_plan_organizations_v orgs,
4362: msc_plan_buckets mpb,
4363: msc_system_items msi,
4364: msc_plans mp

Line 4413: FROM msc_supplies s,

4409: s.sr_instance_id,
4410: 2 /* Details not enabled for Manual Planned orders */,
4411: s.organization_id,
4412: s.plan_id
4413: FROM msc_supplies s,
4414: msc_plan_organizations_v orgs
4415: WHERE s.release_errors is NULL
4416: AND nvl(s.cfm_routing_flag,0) = 3
4417: AND s.implement_quantity > 0

Line 4607: msc_supplies s

4603: FROM msc_trading_partners tp,
4604: msc_parameters param,
4605: msc_system_items msi,
4606: msc_process_effectivity mpe,
4607: msc_supplies s
4608: WHERE tp.sr_tp_id= msi.organization_id
4609: AND tp.sr_instance_id= msi.sr_instance_id
4610: AND tp.partner_type=3
4611: AND param.organization_id = msi.organization_id

Line 4677: From msc_supplies s,

4673: nwk.from_op_seq_num,
4674: nwk.to_op_seq_num,
4675: 3,
4676: s.sr_instance_id
4677: From msc_supplies s,
4678: msc_operation_networks nwk,
4679: msc_apps_instances ins,
4680: msc_parameters param
4681: Where nwk.plan_id = s.plan_id

Line 4735: From msc_supplies s,

4731: max(res.END_DATE),
4732: 3,
4733: s.sr_instance_id,
4734: max(nvl(res.CUMMULATIVE_QUANTITY,0))
4735: From msc_supplies s,
4736: msc_resource_requirements res,
4737: msc_apps_instances ins,
4738: msc_parameters param
4739: Where res.plan_id = s.plan_id

Line 4835: From msc_supplies s,

4831: ROUND(s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1) ,6),
4832: (s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1))
4833: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
4834: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
4835: From msc_supplies s,
4836: msc_resource_requirements res,
4837: msc_apps_instances ins,
4838: msc_parameters param,
4839: msc_department_resources mdr,

Line 4921: From msc_supplies s,

4917: md.USING_REQUIREMENT_QUANTITY,
4918: md.USING_REQUIREMENT_QUANTITY,
4919: 3,
4920: s.sr_instance_id
4921: From msc_supplies s,
4922: msc_demands md,
4923: msc_system_items icomp,
4924: msc_system_items icomp1,
4925: msc_system_items icomp2,

Line 5018: From msc_supplies s,

5014: -- dsr: add folllowing columns
5015: , res.orig_resource_seq_num
5016: , res.resource_seq_num
5017: , res.parent_seq_num
5018: From msc_supplies s,
5019: msc_resource_requirements res,
5020: msc_apps_instances ins,
5021: msc_parameters param
5022: Where res.plan_id = s.plan_id

Line 5115: msc_supplies s,

5111: msc_trading_partners tp,
5112: msc_resource_requirements resreq,
5113: msc_resource_instance_reqs res_instreq, -- changed from design doc
5114: msc_dept_res_instances dep_res_inst,
5115: msc_supplies s,
5116: msc_apps_instances ins,
5117: msc_parameters param
5118: WHERE
5119: tp.sr_tp_id=s.organization_id

Line 5234: msc_supplies s,

5230: msc_trading_partners tp,
5231: msc_resource_requirements resreq,
5232: msc_resource_instance_reqs res_instreq,
5233: msc_dept_res_instances dep_res_inst,
5234: msc_supplies s,
5235: msc_apps_instances ins,
5236: msc_parameters param
5237: WHERE
5238: tp.sr_tp_id=s.organization_id

Line 5283: update msc_supplies

5279: ); */
5280:
5281: -- dsr end
5282: FORALL j IN 1..lv_job_count
5283: update msc_supplies
5284: set releasable = RELEASE_ATTEMPTED
5285: ,batch_id = nvl(batch_id,g_batch_id)
5286: where plan_id = arg_plan_id
5287: and transaction_id= lv_transaction_id(j);

Line 5340: msc_supplies s,

5336: 2),2),2)),
5337: s.organization_id,
5338: s.plan_id
5339: FROM msc_plans mp,
5340: msc_supplies s,
5341: msc_plan_organizations_v orgs,
5342: msc_plan_buckets mpb
5343: WHERE mp.plan_id = :arg_plan_id
5344: AND s.release_errors is NULL

Line 5538: msc_supplies s,

5534: , s.requested_completion_date
5535: FROM msc_trading_partners tp,
5536: msc_parameters param,
5537: msc_system_items msi,
5538: msc_supplies s,
5539: msc_plan_organizations_v orgs
5540: WHERE tp.sr_tp_id= msi.organization_id
5541: AND tp.sr_instance_id= msi.sr_instance_id
5542: AND tp.partner_type=3

Line 5615: From msc_supplies s,

5611: decode(nwk.from_op_seq_num, 50000 ,null,nwk.from_op_seq_num),
5612: nwk.to_op_seq_num,
5613: 3,
5614: s.sr_instance_id
5615: From msc_supplies s,
5616: msc_job_operation_networks nwk,
5617: msc_apps_instances ins,
5618: msc_parameters param
5619: Where nwk.plan_id = s.plan_id

Line 5675: From msc_supplies s,

5671: max(res.END_DATE),
5672: 3,
5673: s.sr_instance_id,
5674: max(nvl(res.CUMMULATIVE_QUANTITY,0))
5675: From msc_supplies s,
5676: msc_resource_requirements res,
5677: msc_apps_instances ins,
5678: msc_parameters param
5679: Where res.plan_id = s.plan_id

Line 5780: From msc_supplies s,

5776: ROUND(s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1) ,6),
5777: (s.new_order_quantity/nvl(res.REVERSE_CUMULATIVE_YIELD,1))
5778: ) ) ))* decode(mdr.efficiency,NULL,100,0,100,mdr.efficiency)/100 * decode(mdr.utilization,NULL,100,0,100,mdr.utilization)/100, res.RESOURCE_HOURS)
5779: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
5780: From msc_supplies s,
5781: msc_resource_requirements res,
5782: msc_apps_instances ins,
5783: msc_parameters param,
5784: msc_department_resources mdr,

Line 5868: From msc_supplies s,

5864: md.USING_REQUIREMENT_QUANTITY,
5865: md.USING_REQUIREMENT_QUANTITY,
5866: 3,
5867: s.sr_instance_id
5868: From msc_supplies s,
5869: msc_demands md,
5870: msc_system_items icomp,
5871: msc_system_items icomp1,
5872: msc_system_items icomp2,

Line 5966: From msc_supplies s,

5962: -- dsr
5963: res.orig_resource_seq_num,
5964: res.resource_seq_num,
5965: res.parent_seq_num
5966: From msc_supplies s,
5967: msc_resource_requirements res,
5968: msc_apps_instances ins,
5969: msc_parameters param
5970: Where res.plan_id = s.plan_id

Line 6067: msc_supplies s,

6063: FROM msc_trading_partners tp,
6064: msc_resource_requirements resreq,
6065: msc_resource_instance_reqs res_instreq, -- changed from design doc
6066: msc_dept_res_instances dep_res_inst,
6067: msc_supplies s,
6068: msc_apps_instances ins,
6069: msc_parameters param
6070: WHERE
6071: tp.sr_tp_id=s.organization_id

Line 6185: msc_supplies s,

6181: msc_trading_partners tp,
6182: msc_resource_requirements resreq,
6183: msc_resource_instance_reqs res_instreq,
6184: msc_dept_res_instances dep_res_inst,
6185: msc_supplies s,
6186: msc_apps_instances ins,
6187: msc_parameters param
6188: WHERE
6189: tp.sr_tp_id=s.organization_id

Line 6233: update msc_supplies

6229: || sql%rowcount); */
6230:
6231:
6232: FORALL j IN 1..lv_resched_jobs
6233: update msc_supplies
6234: set releasable = RELEASE_ATTEMPTED
6235: ,batch_id = nvl(batch_id,g_batch_id)
6236: where plan_id = arg_plan_id
6237: and transaction_id= lv_transaction_id(j);

Line 6291: FROM msc_supplies

6287: CURSOR c_release_dtls(p_transaction_id number,
6288: p_plan_id number) IS
6289: SELECT COUNT(1) FROM (
6290: SELECT count(1)
6291: FROM msc_supplies
6292: WHERE implement_alternate_bom is not null
6293: and transaction_id = p_transaction_id
6294: AND plan_id = p_plan_id
6295: and rownum < 2

Line 6397: FROM msc_supplies s,

6393: NVL(s.new_order_quantity, 0),
6394: NVL(s.implement_quantity, 0)
6395: -- NVL(s.qty_scrapped, 0),
6396: -- NVL(s.qty_completed, 0)
6397: FROM msc_supplies s,
6398: msc_plan_organizations_v orgs,
6399: msc_plan_buckets mpb,
6400: msc_system_items msi,
6401: msc_plans mp

Line 6455: FROM msc_supplies s,

6451: NVL(s.new_order_quantity, 0),
6452: NVL(s.implement_quantity, 0)
6453: -- NVL(s.qty_scrapped, 0),
6454: -- NVL(s.qty_completed, 0)
6455: FROM msc_supplies s,
6456: msc_plan_organizations_v orgs
6457: WHERE s.release_errors is NULL
6458: AND s.implement_quantity > 0
6459: AND s.organization_id = orgs.planned_organization

Line 6747: msc_supplies s,

6743: FROM msc_trading_partners tp,
6744: msc_parameters param,
6745: msc_system_items msi,
6746: msc_process_effectivity mpe,
6747: msc_supplies s,
6748: msc_boms mb
6749: WHERE tp.sr_tp_id= msi.organization_id
6750: AND tp.sr_instance_id= msi.sr_instance_id
6751: AND tp.partner_type=3

Line 6885: msc_supplies s

6881: FROM msc_trading_partners tp,
6882: msc_resource_requirements resreq,
6883: msc_parameters param,
6884: msc_system_items msi,
6885: msc_supplies s
6886: WHERE tp.sr_tp_id= msi.organization_id
6887: AND tp.sr_instance_id= msi.sr_instance_id
6888: AND tp.partner_type=3
6889: AND resreq.sr_instance_id= s.sr_instance_id

Line 7047: msc_supplies s,

7043: FROM msc_trading_partners tp,
7044: msc_resource_requirements resreq,
7045: msc_parameters param,
7046: msc_system_items msi,
7047: msc_supplies s,
7048: msc_department_resources mdr
7049: WHERE tp.sr_tp_id= msi.organization_id
7050: AND tp.sr_instance_id= msi.sr_instance_id
7051: AND tp.partner_type=3

Line 7173: msc_supplies s

7169: msc_system_items icomp,
7170: msc_demands md,
7171: msc_parameters param,
7172: msc_system_items msi,
7173: msc_supplies s
7174: WHERE /*
7175: ( md.SUBST_ITEM_FLAG <> 1
7176: OR md.SUBST_ITEM_FLAG IS NULL) */
7177: not exists (select 'x'

Line 7280: msc_supplies co,

7276: nvl(s.implement_uom_code,msi.uom_code),
7277: s.sr_instance_id
7278: FROM msc_trading_partners tp,
7279: msc_system_items icomp,
7280: msc_supplies co,
7281: msc_parameters param,
7282: msc_system_items msi,
7283: msc_supplies s
7284: WHERE /* not exists (select 'x'

Line 7283: msc_supplies s

7279: msc_system_items icomp,
7280: msc_supplies co,
7281: msc_parameters param,
7282: msc_system_items msi,
7283: msc_supplies s
7284: WHERE /* not exists (select 'x'
7285: from msc_exception_details excp
7286: where excp.plan_id = msi.plan_id
7287: and excp.number1 = s.transaction_id

Line 7403: msc_supplies s

7399: msc_system_items icomp,
7400: msc_demands md,
7401: msc_parameters param,
7402: msc_system_items msi,
7403: msc_supplies s
7404: WHERE tp.sr_tp_id= msi.organization_id
7405: AND tp.sr_instance_id= msi.sr_instance_id
7406: AND tp.partner_type=3
7407: AND sr_item.inventory_item_id= subcomp.inventory_item_id

Line 7548: msc_supplies s,

7544: FROM msc_trading_partners tp,
7545: msc_resource_requirements resreq,
7546: msc_parameters param,
7547: msc_system_items msi,
7548: msc_supplies s,
7549: msc_department_resources mdr
7550: WHERE tp.sr_tp_id= msi.organization_id
7551: AND tp.sr_instance_id= msi.sr_instance_id
7552: AND tp.partner_type=3

Line 7662: msc_supplies s

7658: msc_trading_partners tp,
7659: msc_resource_requirements resreq,
7660: msc_resource_instance_reqs res_instreq,
7661: msc_dept_res_instances dep_res_inst,
7662: msc_supplies s
7663: WHERE
7664: tp.sr_tp_id=s.organization_id
7665: AND tp.sr_instance_id= s.sr_instance_id
7666: AND tp.partner_type=3

Line 7774: msc_supplies s

7770: msc_trading_partners tp,
7771: msc_resource_requirements resreq,
7772: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
7773: msc_dept_res_instances dep_res_inst,
7774: msc_supplies s
7775: WHERE
7776: tp.sr_tp_id=s.organization_id
7777: AND tp.sr_instance_id= s.sr_instance_id
7778: AND tp.partner_type=3

Line 7870: msc_supplies s,

7866: resreq.resource_seq_num
7867: FROM
7868: msc_trading_partners tp,
7869: msc_resource_requirements resreq,
7870: msc_supplies s,
7871: msc_resource_charges chg
7872: WHERE
7873: tp.sr_tp_id=s.organization_id
7874: AND tp.sr_instance_id= s.sr_instance_id

Line 7896: update msc_supplies

7892: END IF; /* End of l_count = 1 */
7893: -- dsr ends here
7894:
7895: FORALL j IN 1..lv_job_count
7896: update msc_supplies
7897: set releasable = RELEASE_ATTEMPTED
7898: ,batch_id = nvl(batch_id,g_batch_id)
7899: where plan_id = arg_plan_id
7900: and transaction_id= lv_transaction_id(j);

Line 7950: FROM msc_supplies

7946:
7947: CURSOR c_release_dtls(p_transaction_id number,
7948: p_plan_id number) IS
7949: SELECT count(1)
7950: FROM msc_supplies
7951: WHERE implement_alternate_bom is not null
7952: and transaction_id = p_transaction_id
7953: and rownum < 2
7954: UNION

Line 8010: FROM msc_supplies s,

8006: NVL(s.new_order_quantity, 0),
8007: NVL(s.implement_quantity, 0),
8008: NVL(s.qty_scrapped, 0),
8009: NVL(s.qty_completed, 0)
8010: FROM msc_supplies s,
8011: msc_plans mp,
8012: msc_plan_organizations_v orgs,
8013: msc_plan_buckets mpb
8014: WHERE s.release_errors is NULL

Line 8274: msc_supplies s,

8270: , s.requested_completion_date -- dsr
8271: FROM msc_trading_partners tp,
8272: msc_parameters param,
8273: msc_system_items msi,
8274: msc_supplies s,
8275: msc_plan_organizations_v orgs,
8276: msc_boms mb
8277: WHERE tp.sr_tp_id= msi.organization_id
8278: AND tp.sr_instance_id= msi.sr_instance_id

Line 8410: msc_supplies s

8406: FROM msc_trading_partners tp,
8407: msc_resource_requirements resreq,
8408: msc_parameters param,
8409: msc_system_items msi,
8410: msc_supplies s
8411: WHERE tp.sr_tp_id= msi.organization_id
8412: AND tp.sr_instance_id= msi.sr_instance_id
8413: AND tp.partner_type=3
8414: AND resreq.sr_instance_id= s.sr_instance_id

Line 8566: msc_supplies s

8562: FROM msc_trading_partners tp,
8563: msc_resource_requirements resreq,
8564: msc_parameters param,
8565: msc_system_items msi,
8566: msc_supplies s
8567: WHERE tp.sr_tp_id= msi.organization_id
8568: AND tp.sr_instance_id= msi.sr_instance_id
8569: AND tp.partner_type=3
8570: AND resreq.sr_instance_id= s.sr_instance_id

Line 8693: msc_supplies s

8689: msc_system_items icomp,
8690: msc_demands md,
8691: msc_parameters param,
8692: msc_system_items msi,
8693: msc_supplies s
8694: WHERE /*
8695: ( md.SUBST_ITEM_FLAG <> 1
8696: OR md.SUBST_ITEM_FLAG IS NULL) */
8697: not exists (select 'x'

Line 8824: msc_supplies co,

8820: s.disposition_id
8821: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8822: FROM msc_trading_partners tp,
8823: msc_system_items icomp,
8824: msc_supplies co,
8825: msc_parameters param,
8826: msc_system_items msi,
8827: msc_supplies s
8828: WHERE /*not exists (select 'x'

Line 8827: msc_supplies s

8823: msc_system_items icomp,
8824: msc_supplies co,
8825: msc_parameters param,
8826: msc_system_items msi,
8827: msc_supplies s
8828: WHERE /*not exists (select 'x'
8829: from msc_exception_details excp
8830: where excp.plan_id = msi.plan_id
8831: and excp.number1 = s.transaction_id

Line 8961: msc_supplies s

8957: FROM msc_trading_partners tp,
8958: msc_resource_requirements resreq,
8959: msc_parameters param,
8960: msc_system_items msi,
8961: msc_supplies s
8962: WHERE tp.sr_tp_id= msi.organization_id
8963: AND tp.sr_instance_id= msi.sr_instance_id
8964: AND tp.partner_type=3
8965: AND resreq.sr_instance_id= s.sr_instance_id

Line 9069: msc_supplies s

9065: msc_trading_partners tp,
9066: msc_resource_requirements resreq,
9067: msc_resource_instance_reqs res_instreq,
9068: msc_dept_res_instances dep_res_inst,
9069: msc_supplies s
9070: WHERE
9071: tp.sr_tp_id=s.organization_id
9072: AND tp.sr_instance_id= s.sr_instance_id
9073: AND tp.partner_type=3

Line 9187: msc_supplies s

9183: msc_trading_partners tp,
9184: msc_resource_requirements resreq,
9185: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
9186: msc_dept_res_instances dep_res_inst,
9187: msc_supplies s
9188: WHERE
9189: tp.sr_tp_id=s.organization_id
9190: AND tp.sr_instance_id= s.sr_instance_id
9191: AND tp.partner_type=3

Line 9289: msc_supplies s,

9285: , resreq.resource_seq_num
9286: FROM
9287: msc_trading_partners tp,
9288: msc_resource_requirements resreq,
9289: msc_supplies s,
9290: msc_resource_charges chg
9291: WHERE
9292: tp.sr_tp_id=s.organization_id
9293: AND tp.sr_instance_id= s.sr_instance_id

Line 9318: update msc_supplies

9314: -- dsr ends here
9315: END IF; /* End of l_count = 1 */
9316:
9317: FORALL j IN 1..lv_job_count
9318: update msc_supplies
9319: set releasable = RELEASE_ATTEMPTED
9320: ,batch_id = nvl(batch_id,g_batch_id)
9321: where plan_id = arg_plan_id
9322: and transaction_id= lv_transaction_id(j);

Line 9412: msc_supplies s,

9408: FROM msc_trading_partners tp,
9409: msc_parameters param,
9410: msc_system_items msi,
9411: msc_process_effectivity mpe,
9412: msc_supplies s,
9413: msc_plan_organizations_v orgs
9414: WHERE tp.sr_tp_id= msi.organization_id
9415: AND tp.sr_instance_id= msi.sr_instance_id
9416: AND tp.partner_type=3

Line 9471: update msc_supplies

9467: END IF;
9468:
9469:
9470: IF arg_mode = 'WF' THEN
9471: update msc_supplies
9472: set releasable = RELEASE_ATTEMPTED
9473: ,batch_id = nvl(batch_id,g_batch_id)
9474: where plan_id = arg_plan_id
9475: and transaction_id= arg_transaction_id;

Line 9477: update msc_supplies

9473: ,batch_id = nvl(batch_id,g_batch_id)
9474: where plan_id = arg_plan_id
9475: and transaction_id= arg_transaction_id;
9476: ELSE
9477: update msc_supplies
9478: set releasable = RELEASE_ATTEMPTED
9479: ,batch_id = nvl(batch_id,g_batch_id)
9480: where plan_id = arg_plan_id
9481: and transaction_id in (select source_line_id from msc_wip_job_schedule_interface

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

9610: s.organization_id,
9611: 'P',
9612: mp.operating_unit,
9613: /* for single instance if the organization is modelled then the source_sr_instane_id = sr_instance_id
9614: in msc_supplies so we can safely use mp1 for both cases.
9615: For cross-instance releases get the modeled supplier infor */
9616: decode(s.implement_source_org_id,
9617: NULL, to_number(NULL),
9618: decode(mp1.MODELED_SUPPLIER_ID,

Line 9656: msc_supplies s,

9652: msc_trading_partners mp, -- mtl_parameters mp,
9653: msc_trading_partners mp1,
9654: msc_system_items msi,
9655: msc_system_items msi1,
9656: msc_supplies s,
9657: msc_item_suppliers mis,
9658: msc_plan_organizations_v orgs
9659: WHERE supplier.tp_id(+)=
9660: nvl(s.implement_supplier_id, s.source_supplier_id)

Line 9803: msc_supplies s,

9799: msc_trading_partners mp1,
9800: msc_system_items msi,
9801: msc_system_items msi1,
9802: msc_item_suppliers mis,
9803: msc_supplies s,
9804: msc_plan_organizations_v orgs
9805: WHERE supplier.tp_id(+)=
9806: nvl(s.implement_supplier_id, s.source_supplier_id)
9807: AND supplier.partner_type(+)=1

Line 9948: msc_supplies s,

9944: msc_trading_partners mp1,
9945: msc_system_items msi,
9946: msc_system_items msi1,
9947: msc_item_suppliers mis,
9948: msc_supplies s,
9949: msc_plan_organizations_v orgs
9950: WHERE supplier.tp_id(+)=
9951: nvl(s.implement_supplier_id, s.source_supplier_id)
9952: AND supplier.partner_type(+)=1

Line 10031: update msc_supplies

10027: raise lv_custom;
10028: END IF;
10029:
10030: IF arg_mode = 'WF' THEN
10031: update msc_supplies
10032: set releasable = RELEASE_ATTEMPTED
10033: ,batch_id = nvl(batch_id,g_batch_id)
10034: where plan_id = arg_plan_id
10035: and transaction_id= arg_transaction_id;

Line 10037: update msc_supplies

10033: ,batch_id = nvl(batch_id,g_batch_id)
10034: where plan_id = arg_plan_id
10035: and transaction_id= arg_transaction_id;
10036: ELSE
10037: update msc_supplies
10038: set releasable = RELEASE_ATTEMPTED
10039: ,batch_id = nvl(batch_id,g_batch_id)
10040: where plan_id = arg_plan_id
10041: and transaction_id in (select source_line_id from msc_po_requisitions_interface

Line 10101: msc_supplies s,

10097: FROM --msc_calendar_dates cal1,
10098: --msc_calendar_dates cal2,
10099: msc_trading_partners mp,
10100: msc_system_items msi,
10101: msc_supplies s,
10102: msc_apps_instances mai, -- IR/ISO resch Proj
10103: msc_plan_organizations_v orgs
10104: WHERE --cal1.sr_instance_id= mp.sr_instance_id
10105: --AND cal1.calendar_code = mp.calendar_code

Line 10160: msc_supplies s,

10156: FROM --msc_calendar_dates cal1,
10157: --msc_calendar_dates cal2,
10158: msc_trading_partners mp,
10159: msc_system_items msi,
10160: msc_supplies s,
10161: msc_plan_organizations_v orgs
10162: WHERE --cal1.sr_instance_id= mp.sr_instance_id
10163: --AND cal1.calendar_code = mp.calendar_code
10164: -- AND cal1.exception_set_id = mp.calendar_exception_set_id

Line 10200: update msc_supplies

10196: lv_resched_reqs := 0;
10197: END IF;
10198:
10199: IF arg_mode = 'WF' THEN
10200: update msc_supplies
10201: set releasable = RELEASE_ATTEMPTED
10202: ,batch_id = nvl(batch_id,g_batch_id)
10203: where plan_id = arg_plan_id
10204: and transaction_id= arg_transaction_id;

Line 10207: update msc_supplies

10203: where plan_id = arg_plan_id
10204: and transaction_id= arg_transaction_id;
10205: ELSE
10206: IF v_batch_id_populated = 1 THEN
10207: update msc_supplies
10208: set releasable = RELEASE_ATTEMPTED
10209: where batch_id = g_batch_id;
10210: ELSE
10211: update msc_supplies

Line 10211: update msc_supplies

10207: update msc_supplies
10208: set releasable = RELEASE_ATTEMPTED
10209: where batch_id = g_batch_id;
10210: ELSE
10211: update msc_supplies
10212: set releasable = RELEASE_ATTEMPTED
10213: ,batch_id = g_batch_id
10214: where plan_id = arg_plan_id
10215: and transaction_id in (select source_line_id from msc_po_reschedule_interface);

Line 10269: msc_supplies s,

10265: FROM --msc_calendar_dates cal1,
10266: --msc_calendar_dates cal2,
10267: msc_trading_partners mp,
10268: msc_system_items msi,
10269: msc_supplies s,
10270: msc_plan_organizations_v orgs
10271: WHERE --cal1.sr_instance_id = mp.sr_instance_id
10272: --AND cal1.calendar_code = mp.calendar_code
10273: --AND cal1.exception_set_id = mp.calendar_exception_set_id

Line 10333: update msc_supplies

10329: IN lv_po_number,
10330: OUT lv_return_code;
10331: END IF;
10332:
10333: update msc_supplies
10334: set releasable = RELEASE_ATTEMPTED
10335: ,batch_id = nvl(batch_id,g_batch_id)
10336: where plan_id = arg_plan_id
10337: and transaction_id= arg_transaction_id;

Line 10457: FROM msc_supplies s,

10453: decode( ' || p_l_apps_ver ||' ,4,msi.rounding_control_type,3,msi.rounding_control_type,2),
10454: NVL(s.wip_start_quantity, 0),
10455: NVL(s.new_order_quantity, 0),
10456: NVL(s.implement_quantity, 0)
10457: FROM msc_supplies s,
10458: msc_plan_organizations_v orgs,
10459: msc_plan_buckets mpb,
10460: msc_system_items msi,
10461: msc_plans mp,

Line 10655: msc_supplies s

10651: FROM msc_trading_partners tp,
10652: msc_parameters param,
10653: msc_system_items msi,
10654: msc_process_effectivity mpe,
10655: msc_supplies s
10656: WHERE tp.sr_tp_id= msi.organization_id
10657: AND tp.sr_instance_id= msi.sr_instance_id
10658: AND tp.partner_type=3
10659: AND param.organization_id = msi.organization_id

Line 10698: update msc_supplies

10694:
10695: IF c_count%ISOPEN THEN CLOSE c_count; END IF;
10696:
10697: FORALL j IN 1..lv_job_count
10698: update msc_supplies
10699: set releasable = RELEASE_ATTEMPTED
10700: ,batch_id = nvl(batch_id,g_batch_id)
10701: where plan_id = p_arg_plan_id
10702: and transaction_id= lv_transaction_id(j);

Line 10751: FROM msc_supplies

10747:
10748: CURSOR c_release_dtls(p_transaction_id number,
10749: p_plan_id number) IS
10750: SELECT count(1)
10751: FROM msc_supplies
10752: WHERE implement_alternate_bom is not null
10753: and transaction_id = p_transaction_id
10754: and rownum < 2
10755: UNION

Line 10806: FROM msc_supplies s,

10802: NVL(s.new_order_quantity, 0),
10803: NVL(s.implement_quantity, 0),
10804: NVL(s.qty_scrapped, 0),
10805: NVL(s.qty_completed, 0)
10806: FROM msc_supplies s,
10807: msc_plans mp,
10808: msc_plan_organizations_v orgs,
10809: msc_plan_buckets mpb
10810: WHERE s.release_errors is NULL

Line 11045: msc_supplies s,

11041: , s.requested_completion_date
11042: FROM msc_trading_partners tp,
11043: msc_parameters param,
11044: msc_system_items msi,
11045: msc_supplies s,
11046: msc_plan_organizations_v orgs
11047: WHERE tp.sr_tp_id= msi.organization_id
11048: AND tp.sr_instance_id= msi.sr_instance_id
11049: AND tp.partner_type=3

Line 11164: msc_supplies s

11160: FROM msc_trading_partners tp,
11161: msc_resource_requirements resreq,
11162: msc_parameters param,
11163: msc_system_items msi,
11164: msc_supplies s
11165: WHERE tp.sr_tp_id= msi.organization_id
11166: AND tp.sr_instance_id= msi.sr_instance_id
11167: AND tp.partner_type=3
11168: AND resreq.sr_instance_id= s.sr_instance_id

Line 11315: msc_supplies s

11311: FROM msc_trading_partners tp,
11312: msc_resource_requirements resreq,
11313: msc_parameters param,
11314: msc_system_items msi,
11315: msc_supplies s
11316: WHERE tp.sr_tp_id= msi.organization_id
11317: AND tp.sr_instance_id= msi.sr_instance_id
11318: AND tp.partner_type=3
11319: AND resreq.sr_instance_id= s.sr_instance_id

Line 11420: msc_supplies s

11416: msc_system_items icomp,
11417: msc_demands md,
11418: msc_parameters param,
11419: msc_system_items msi,
11420: msc_supplies s
11421: WHERE /*
11422: ( md.SUBST_ITEM_FLAG <> 1
11423: OR md.SUBST_ITEM_FLAG IS NULL) */
11424: not exists (select 'x'

Line 11533: msc_supplies co,

11529: s.disposition_id
11530: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11531: FROM msc_trading_partners tp,
11532: msc_system_items icomp,
11533: msc_supplies co,
11534: msc_parameters param,
11535: msc_system_items msi,
11536: msc_supplies s
11537: WHERE /*not exists (select 'x'

Line 11536: msc_supplies s

11532: msc_system_items icomp,
11533: msc_supplies co,
11534: msc_parameters param,
11535: msc_system_items msi,
11536: msc_supplies s
11537: WHERE /*not exists (select 'x'
11538: from msc_exception_details excp
11539: where excp.plan_id = msi.plan_id
11540: and excp.number1 = s.transaction_id

Line 11663: msc_supplies s

11659: FROM msc_trading_partners tp,
11660: msc_resource_requirements resreq,
11661: msc_parameters param,
11662: msc_system_items msi,
11663: msc_supplies s
11664: WHERE tp.sr_tp_id= msi.organization_id
11665: AND tp.sr_instance_id= msi.sr_instance_id
11666: AND tp.partner_type=3
11667: AND resreq.sr_instance_id= s.sr_instance_id

Line 11773: msc_supplies s

11769: msc_trading_partners tp,
11770: msc_resource_requirements resreq,
11771: msc_resource_instance_reqs res_instreq,
11772: msc_dept_res_instances dep_res_inst,
11773: msc_supplies s
11774: WHERE
11775: tp.sr_tp_id=s.organization_id
11776: AND tp.sr_instance_id= s.sr_instance_id
11777: AND tp.partner_type=3

Line 11893: msc_supplies s

11889: msc_trading_partners tp,
11890: msc_resource_requirements resreq,
11891: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
11892: msc_dept_res_instances dep_res_inst,
11893: msc_supplies s
11894: WHERE
11895: tp.sr_tp_id=s.organization_id
11896: AND tp.sr_instance_id= s.sr_instance_id
11897: AND tp.partner_type=3

Line 11997: msc_supplies s,

11993: , resreq.resource_seq_num
11994: FROM
11995: msc_trading_partners tp,
11996: msc_resource_requirements resreq,
11997: msc_supplies s,
11998: msc_resource_charges chg
11999: WHERE
12000: tp.sr_tp_id=s.organization_id
12001: AND tp.sr_instance_id= s.sr_instance_id

Line 12023: update msc_supplies

12019: -- dsr ends here
12020: END IF; /* End of l_count = 1 */
12021:
12022: FORALL j IN 1..lv_job_count
12023: update msc_supplies
12024: set releasable = RELEASE_ATTEMPTED
12025: ,batch_id = nvl(batch_id,g_batch_id)
12026: where plan_id = arg_plan_id
12027: and transaction_id= lv_transaction_id(j);

Line 12080: FROM msc_supplies

12076:
12077: CURSOR c_release_dtls(p_transaction_id number,
12078: p_plan_id number) IS
12079: SELECT count(1)
12080: FROM msc_supplies
12081: WHERE implement_alternate_bom is not null
12082: and transaction_id = p_transaction_id
12083: and rownum < 2
12084: UNION

Line 12135: FROM msc_supplies s,

12131: NVL(s.new_order_quantity, 0),
12132: NVL(s.implement_quantity, 0),
12133: NVL(s.qty_scrapped, 0),
12134: NVL(s.qty_completed, 0)
12135: FROM msc_supplies s,
12136: msc_plans mp,
12137: msc_plan_organizations_v orgs,
12138: msc_plan_buckets mpb
12139: WHERE s.release_errors is NULL

Line 12374: msc_supplies s,

12370: , s.requested_completion_date
12371: FROM msc_trading_partners tp,
12372: msc_parameters param,
12373: msc_system_items msi,
12374: msc_supplies s,
12375: msc_plan_organizations_v orgs
12376: WHERE tp.sr_tp_id= msi.organization_id
12377: AND tp.sr_instance_id= msi.sr_instance_id
12378: AND tp.partner_type=3

Line 12493: msc_supplies s

12489: FROM msc_trading_partners tp,
12490: msc_resource_requirements resreq,
12491: msc_parameters param,
12492: msc_system_items msi,
12493: msc_supplies s
12494: WHERE tp.sr_tp_id= msi.organization_id
12495: AND tp.sr_instance_id= msi.sr_instance_id
12496: AND tp.partner_type=3
12497: AND resreq.sr_instance_id= s.sr_instance_id

Line 12644: msc_supplies s

12640: FROM msc_trading_partners tp,
12641: msc_resource_requirements resreq,
12642: msc_parameters param,
12643: msc_system_items msi,
12644: msc_supplies s
12645: WHERE tp.sr_tp_id= msi.organization_id
12646: AND tp.sr_instance_id= msi.sr_instance_id
12647: AND tp.partner_type=3
12648: AND resreq.sr_instance_id= s.sr_instance_id

Line 12750: msc_supplies s

12746: msc_system_items icomp,
12747: msc_demands md,
12748: msc_parameters param,
12749: msc_system_items msi,
12750: msc_supplies s
12751: WHERE /*
12752: ( md.SUBST_ITEM_FLAG <> 1
12753: OR md.SUBST_ITEM_FLAG IS NULL)
12754: not exists (select 'x'

Line 12864: msc_supplies co,

12860: s.disposition_id
12861: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12862: FROM msc_trading_partners tp,
12863: msc_system_items icomp,
12864: msc_supplies co,
12865: msc_parameters param,
12866: msc_system_items msi,
12867: msc_supplies s
12868: WHERE /*not exists (select 'x'

Line 12867: msc_supplies s

12863: msc_system_items icomp,
12864: msc_supplies co,
12865: msc_parameters param,
12866: msc_system_items msi,
12867: msc_supplies s
12868: WHERE /*not exists (select 'x'
12869: from msc_exception_details excp
12870: where excp.plan_id = msi.plan_id
12871: and excp.number1 = s.transaction_id

Line 12994: msc_supplies s

12990: FROM msc_trading_partners tp,
12991: msc_resource_requirements resreq,
12992: msc_parameters param,
12993: msc_system_items msi,
12994: msc_supplies s
12995: WHERE tp.sr_tp_id= msi.organization_id
12996: AND tp.sr_instance_id= msi.sr_instance_id
12997: AND tp.partner_type=3
12998: AND resreq.sr_instance_id= s.sr_instance_id

Line 13104: msc_supplies s

13100: msc_trading_partners tp,
13101: msc_resource_requirements resreq,
13102: msc_resource_instance_reqs res_instreq,
13103: msc_dept_res_instances dep_res_inst,
13104: msc_supplies s
13105: WHERE
13106: tp.sr_tp_id=s.organization_id
13107: AND tp.sr_instance_id= s.sr_instance_id
13108: AND tp.partner_type=3

Line 13224: msc_supplies s

13220: msc_trading_partners tp,
13221: msc_resource_requirements resreq,
13222: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
13223: msc_dept_res_instances dep_res_inst,
13224: msc_supplies s
13225: WHERE
13226: tp.sr_tp_id=s.organization_id
13227: AND tp.sr_instance_id= s.sr_instance_id
13228: AND tp.partner_type=3

Line 13328: msc_supplies s,

13324: , resreq.resource_seq_num
13325: FROM
13326: msc_trading_partners tp,
13327: msc_resource_requirements resreq,
13328: msc_supplies s,
13329: msc_resource_charges chg
13330: WHERE
13331: tp.sr_tp_id=s.organization_id
13332: AND tp.sr_instance_id= s.sr_instance_id

Line 13434: msc_supplies ms,

13430: msc_system_items icompnew,
13431: msc_demands md,
13432: msc_parameters param,
13433: msc_system_items msi,
13434: msc_supplies ms,
13435: msc_exception_details med
13436: WHERE med.exception_type = WORK_ORDER_SUB_COMPONENT
13437: AND med.plan_id = arg_plan_id
13438: and med.number1 = ms.transaction_id

Line 13474: update msc_supplies

13470: -- dsr ends here
13471: END IF; /* End of l_count = 1 */
13472:
13473: FORALL j IN 1..lv_job_count
13474: update msc_supplies
13475: set releasable = RELEASE_ATTEMPTED
13476: ,batch_id = nvl(batch_id,g_batch_id)
13477: where plan_id = arg_plan_id
13478: and transaction_id= lv_transaction_id(j);