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

Line 341: -- MSC_DEMANDS and MSC_SUPPLIES

337: l_plan_type NUMBER := 1;
338:
339: -- --------------------------------------------
340: -- This cursor selects the snapshot activity in
341: -- MSC_DEMANDS and MSC_SUPPLIES
342: -- for the items per organizatio for a plan..
343: --/*Added decode to PURCH_REQ,PLANNED_ORDER,DEMAND_PLANNED_ORDER for bug 12795022*/
344: -- --------------------------------------------
345: CURSOR mrp_snapshot_activity IS

Line 346: SELECT /+ INDEX(rec, MSC_SUPPLIES_N1) /

342: -- for the items per organizatio for a plan..
343: --/*Added decode to PURCH_REQ,PLANNED_ORDER,DEMAND_PLANNED_ORDER for bug 12795022*/
344: -- --------------------------------------------
345: CURSOR mrp_snapshot_activity IS
346: SELECT /*+ INDEX(rec, MSC_SUPPLIES_N1) */
347: list.number5 item_id,
348: list.number6 org_id,
349: list.number3 inst_id,
350: DECODE(rec.order_type,

Line 415: msc_supplies rec,

411: 0 cost
412: FROM msc_form_query list,
413: msc_trading_partners param,
414: msc_system_items msi,
415: msc_supplies rec,
416: msc_calendar_dates dates
417: WHERE (arg_res_level = 1
418: OR (arg_res_level = 2
419: AND rec.project_id is NULL)

Line 641: from msc_supplies mr

637: l_plan_type = 4 and -- 5086979: IO plan don't show past due demand
638: trunc(mgr.using_assembly_demand_date) >= trunc(l_plan_start_date))
639: AND not exists (
640: select 'cancelled IR'
641: from msc_supplies mr
642: where mgr.origination_type in (30,6)
643: and mgr.disposition_id = mr.transaction_id
644: and mgr.plan_id = mr.plan_id
645: and mgr.sr_instance_id = mr.sr_instance_id

Line 3280: --< bug5449978--if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies

3276: SELECT msc_form_query_s.nextval
3277: INTO l_query_id
3278: FROM dual;
3279:
3280: --< bug5449978--if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies
3281: OPEN plan_start_c;
3282: FETCH plan_start_c INTO l_plan_start_date, l_plan_type, l_optimized_plan, l_enforce_sup_cap_constraints, l_constraints;
3283: CLOSE plan_start_c;
3284:

Line 3285: --if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies

3281: OPEN plan_start_c;
3282: FETCH plan_start_c INTO l_plan_start_date, l_plan_type, l_optimized_plan, l_enforce_sup_cap_constraints, l_constraints;
3283: CLOSE plan_start_c;
3284:
3285: --if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies
3286: --BUG5609299--modified previous fix so that we use msc_supplies for unconstrained DRP or unconstrained ASCP plans.
3287: if (l_plan_type=5 ) or (l_plan_type=1 and l_constraints=0) then
3288: g_use_sup_req:=0; -- do not use msc_supplier_requirements
3289: else

Line 3286: --BUG5609299--modified previous fix so that we use msc_supplies for unconstrained DRP or unconstrained ASCP plans.

3282: FETCH plan_start_c INTO l_plan_start_date, l_plan_type, l_optimized_plan, l_enforce_sup_cap_constraints, l_constraints;
3283: CLOSE plan_start_c;
3284:
3285: --if plan is drp or unconstrained ascp or any plan where enforce_supplier capacity constraints is off, fallback to msc_supplies
3286: --BUG5609299--modified previous fix so that we use msc_supplies for unconstrained DRP or unconstrained ASCP plans.
3287: if (l_plan_type=5 ) or (l_plan_type=1 and l_constraints=0) then
3288: g_use_sup_req:=0; -- do not use msc_supplier_requirements
3289: else
3290: g_use_sup_req:=1; -- use msc_supplier_requirements

Line 3490: l_date := ' trunc(ms.new_dock_date) ';-- use msc_supplies

3486: END IF; -- only construct sql for capacity first time through cursor
3487: ELSE -- supplier requirements
3488:
3489: if g_use_sup_req=0 then
3490: l_date := ' trunc(ms.new_dock_date) ';-- use msc_supplies
3491: else
3492: l_date := ' trunc(mr.consumption_date) ';-- use msc_supplier_requirements
3493: end if;
3494:

Line 3497: ' FROM msc_supplies ms,'||

3493: end if;
3494:
3495: sql_stmt_2 := sql_stmt ||
3496: ' ms.transaction_id '||
3497: ' FROM msc_supplies ms,'||
3498: ' msc_supplier_requirements mr '||
3499: ' WHERE ms.plan_id = :p_plan_id' ||
3500: ' AND ms.inventory_item_id = :req_item_id' ||
3501: ' and nvl(ms.source_supplier_id,ms.supplier_id )= :p_supplier_id'||

Line 3625: sql_stmt := sql_stmt || sql_stmt_4 || ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 79' ;

3621: -- ---------------------------
3622: ELSIF (l_isHp = true AND p_rowtype = 325) THEN -- POH, PAB def /*Added item_type_value for bug 12427785*/
3623: sql_stmt := sql_stmt || ' AND trunc(nvl(firm_date,new_due_date)) <= '''|| p_end_date|| '''AND order_type in (77,78,81,18,11,5,1,2,30) AND item_type_value = 2';
3624: ELSIF (l_isHp = true AND p_rowtype = 295) THEN --Planned Repair Work Orders
3625: sql_stmt := sql_stmt || sql_stmt_4 || ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 79' ;
3626: ELSIF (l_isHp = true AND p_rowtype = 330) THEN --Maintenance Work Orders
3627: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type in (70,92)' ;
3628: ELSIF (l_isHp = true AND p_rowtype = 305) THEN --Defective Part Demand
3629: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_DEMANDS''' || 'AND order_type in (77,78,30) AND item_type_value = 2' ;

Line 3627: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type in (70,92)' ;

3623: sql_stmt := sql_stmt || ' AND trunc(nvl(firm_date,new_due_date)) <= '''|| p_end_date|| '''AND order_type in (77,78,81,18,11,5,1,2,30) AND item_type_value = 2';
3624: ELSIF (l_isHp = true AND p_rowtype = 295) THEN --Planned Repair Work Orders
3625: sql_stmt := sql_stmt || sql_stmt_4 || ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 79' ;
3626: ELSIF (l_isHp = true AND p_rowtype = 330) THEN --Maintenance Work Orders
3627: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type in (70,92)' ;
3628: ELSIF (l_isHp = true AND p_rowtype = 305) THEN --Defective Part Demand
3629: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_DEMANDS''' || 'AND order_type in (77,78,30) AND item_type_value = 2' ;
3630: ELSIF (l_isHp = true AND p_rowtype = 310) THEN --Returns Forecast
3631: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 81' ;

Line 3631: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 81' ;

3627: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type in (70,92)' ;
3628: ELSIF (l_isHp = true AND p_rowtype = 305) THEN --Defective Part Demand
3629: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_DEMANDS''' || 'AND order_type in (77,78,30) AND item_type_value = 2' ;
3630: ELSIF (l_isHp = true AND p_rowtype = 310) THEN --Returns Forecast
3631: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 81' ;
3632: ELSIF (l_isHp = true AND p_rowtype = 315) THEN --Defective On-Hand
3633: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 18 AND item_type_value = 2' ;
3634: ELSIF (l_isHp = true AND p_rowtype = 320) THEN --Defectives In-Transit
3635: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type in (11,5,2) AND item_type_value = 2' ;

Line 3633: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 18 AND item_type_value = 2' ;

3629: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_DEMANDS''' || 'AND order_type in (77,78,30) AND item_type_value = 2' ;
3630: ELSIF (l_isHp = true AND p_rowtype = 310) THEN --Returns Forecast
3631: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 81' ;
3632: ELSIF (l_isHp = true AND p_rowtype = 315) THEN --Defective On-Hand
3633: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 18 AND item_type_value = 2' ;
3634: ELSIF (l_isHp = true AND p_rowtype = 320) THEN --Defectives In-Transit
3635: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type in (11,5,2) AND item_type_value = 2' ;
3636: ELSIF (l_isHp = true AND p_rowtype = 340) THEN --Planned Defective Transfer Orders
3637: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =5 AND item_type_value = 2' ;

Line 3635: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type in (11,5,2) AND item_type_value = 2' ;

3631: sql_stmt := sql_stmt ||sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 81' ;
3632: ELSIF (l_isHp = true AND p_rowtype = 315) THEN --Defective On-Hand
3633: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 18 AND item_type_value = 2' ;
3634: ELSIF (l_isHp = true AND p_rowtype = 320) THEN --Defectives In-Transit
3635: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type in (11,5,2) AND item_type_value = 2' ;
3636: ELSIF (l_isHp = true AND p_rowtype = 340) THEN --Planned Defective Transfer Orders
3637: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =5 AND item_type_value = 2' ;
3638: ELSIF (l_isHp = true AND p_rowtype = 350) THEN --External Repair Order
3639: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =74' ;

Line 3637: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =5 AND item_type_value = 2' ;

3633: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' || 'AND order_type = 18 AND item_type_value = 2' ;
3634: ELSIF (l_isHp = true AND p_rowtype = 320) THEN --Defectives In-Transit
3635: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type in (11,5,2) AND item_type_value = 2' ;
3636: ELSIF (l_isHp = true AND p_rowtype = 340) THEN --Planned Defective Transfer Orders
3637: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =5 AND item_type_value = 2' ;
3638: ELSIF (l_isHp = true AND p_rowtype = 350) THEN --External Repair Order
3639: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =74' ;
3640: ELSIF (l_isHp = true AND p_rowtype = 345) THEN --Planned Defective Part Demand
3641: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_DEMANDS''' ||'AND order_type =1 AND item_type_value = 2' ;

Line 3639: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =74' ;

3635: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type in (11,5,2) AND item_type_value = 2' ;
3636: ELSIF (l_isHp = true AND p_rowtype = 340) THEN --Planned Defective Transfer Orders
3637: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =5 AND item_type_value = 2' ;
3638: ELSIF (l_isHp = true AND p_rowtype = 350) THEN --External Repair Order
3639: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_SUPPLIES''' ||'AND order_type =74' ;
3640: ELSIF (l_isHp = true AND p_rowtype = 345) THEN --Planned Defective Part Demand
3641: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_DEMANDS''' ||'AND order_type =1 AND item_type_value = 2' ;
3642:
3643:

Line 3696: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3692: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3693: ' AND order_type =5 ';
3694: ELSIF ((l_isHp = true AND p_rowtype = 81) OR -- WIP
3695: (l_isDrp = true AND p_rowtype = 140)) THEN
3696: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3697: ' AND order_type in (3,7,14,15,27,28) ';
3698: ELSIF p_rowtype = 82 THEN -- Flow schedule
3699: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3700: ' AND order_type = 28 ';

Line 3699: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3695: (l_isDrp = true AND p_rowtype = 140)) THEN
3696: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3697: ' AND order_type in (3,7,14,15,27,28) ';
3698: ELSIF p_rowtype = 82 THEN -- Flow schedule
3699: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3700: ' AND order_type = 28 ';
3701: ELSIF ((l_isHp = true AND p_rowtype = 83) OR -- Purchase Orders
3702: (l_isDrp = true AND p_rowtype = 190)) THEN
3703: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

Line 3703: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3699: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3700: ' AND order_type = 28 ';
3701: ELSIF ((l_isHp = true AND p_rowtype = 83) OR -- Purchase Orders
3702: (l_isDrp = true AND p_rowtype = 190)) THEN
3703: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3704: ' AND order_type = 1 ';
3705:
3706: ELSIF ((l_isHp = true AND p_rowtype = 85) OR -- Requisitions
3707: (l_isDrp = true AND p_rowtype = 240)) THEN

Line 3708: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3704: ' AND order_type = 1 ';
3705:
3706: ELSIF ((l_isHp = true AND p_rowtype = 85) OR -- Requisitions
3707: (l_isDrp = true AND p_rowtype = 240)) THEN
3708: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3709: ' AND order_type in (2,53) AND item_type_value = 1';
3710: ELSIF ((l_isHp = true AND p_rowtype = 87) OR -- In Transit
3711: (l_isDrp = true AND p_rowtype = 230)) THEN
3712: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

Line 3712: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3708: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3709: ' AND order_type in (2,53) AND item_type_value = 1';
3710: ELSIF ((l_isHp = true AND p_rowtype = 87) OR -- In Transit
3711: (l_isDrp = true AND p_rowtype = 230)) THEN
3712: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3713: ' AND order_type = 11 ';
3714: ELSIF ((l_isHp = true AND p_rowtype = 89) OR -- In Receiving
3715: (l_isDrp = true AND p_rowtype = 150)) THEN
3716: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

Line 3716: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3712: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3713: ' AND order_type = 11 ';
3714: ELSIF ((l_isHp = true AND p_rowtype = 89) OR -- In Receiving
3715: (l_isDrp = true AND p_rowtype = 150)) THEN
3716: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3717: ' AND order_type in (8,12) ';
3718:
3719: ELSIF ((l_isHp = true AND p_rowtype = 90) OR
3720: -- Planned Orders: include planned arrival

Line 3722: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3718:
3719: ELSIF ((l_isHp = true AND p_rowtype = 90) OR
3720: -- Planned Orders: include planned arrival
3721: (l_isDrp = true AND p_rowtype = 250)) THEN
3722: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3723: ' AND order_type in (5,17,51,13) AND item_type_value = 1 ';
3724: ELSIF p_rowtype = 95 THEN
3725: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3726: ' AND order_type = 29 ';

Line 3725: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3721: (l_isDrp = true AND p_rowtype = 250)) THEN
3722: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3723: ' AND order_type in (5,17,51,13) AND item_type_value = 1 ';
3724: ELSIF p_rowtype = 95 THEN
3725: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3726: ' AND order_type = 29 ';
3727: ELSIF p_rowtype = 97 THEN
3728: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3729: ' AND order_type = 32 ';

Line 3728: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3724: ELSIF p_rowtype = 95 THEN
3725: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3726: ' AND order_type = 29 ';
3727: ELSIF p_rowtype = 97 THEN
3728: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3729: ' AND order_type = 32 ';
3730:
3731: ELSIF ((l_isHp = true AND p_rowtype = 100) OR
3732: -- Total Supply: should not include request arrival /*Added order type 70 ,PTS yes for bug 12730764*/

Line 3734: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3730:
3731: ELSIF ((l_isHp = true AND p_rowtype = 100) OR
3732: -- Total Supply: should not include request arrival /*Added order type 70 ,PTS yes for bug 12730764*/
3733: (l_isDrp = true AND p_rowtype = 260)) THEN
3734: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3735: ' AND (order_type in (1,2,3,5,7,8,11,12,13,14,15,17,27,28,29,32,49,51,53,79,74) OR (order_type=70 and produces_to_stock=msc_get_name.lookup_meaning(''SYS_YES_NO'',1)) and AND item_type_value = 1) ';
3736: ELSIF ((l_isHp = true AND p_rowtype = 105) OR -- Beginning on Hand /*Added item_type_value for bug 12534589*/
3737: (l_isDrp = true AND p_rowtype = 130)) THEN
3738: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

Line 3738: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3734: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3735: ' AND (order_type in (1,2,3,5,7,8,11,12,13,14,15,17,27,28,29,32,49,51,53,79,74) OR (order_type=70 and produces_to_stock=msc_get_name.lookup_meaning(''SYS_YES_NO'',1)) and AND item_type_value = 1) ';
3736: ELSIF ((l_isHp = true AND p_rowtype = 105) OR -- Beginning on Hand /*Added item_type_value for bug 12534589*/
3737: (l_isDrp = true AND p_rowtype = 130)) THEN
3738: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3739: ' AND order_type = 18 AND item_type_value = 1';
3740: ELSIF ((l_isHp = true AND p_rowtype = 140) OR -- Current Schdld Receipts
3741: (l_isDrp = true AND p_rowtype = 270)) THEN
3742: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

Line 3742: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3738: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3739: ' AND order_type = 18 AND item_type_value = 1';
3740: ELSIF ((l_isHp = true AND p_rowtype = 140) OR -- Current Schdld Receipts
3741: (l_isDrp = true AND p_rowtype = 270)) THEN
3742: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3743: ' AND order_type in (1,2,3,7,8,11,12,14,15,27,28,29) ';
3744:
3745: -- ---------------------------
3746: -- New Row Types added for DRP

Line 3771: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3767: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3768: ' AND order_type in (30,29,49,3,48,16,17,18,19,20,23) ';
3769:
3770: ELSIF (l_isDrp = true AND p_rowtype = 120) THEN -- Internal Supply
3771: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3772: ' AND order_type in (3,5,7,8,12,18) ';
3773: ELSIF (l_isDrp = true AND p_rowtype = 160) THEN -- Planned Make
3774: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3775: ' AND order_type = 5 ';

Line 3774: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3770: ELSIF (l_isDrp = true AND p_rowtype = 120) THEN -- Internal Supply
3771: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3772: ' AND order_type in (3,5,7,8,12,18) ';
3773: ELSIF (l_isDrp = true AND p_rowtype = 160) THEN -- Planned Make
3774: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3775: ' AND order_type = 5 ';
3776: ELSIF (l_isDrp = true AND p_rowtype = 170) THEN -- Ext Supply
3777: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3778: ' AND order_type in (1,2) ';

Line 3777: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3773: ELSIF (l_isDrp = true AND p_rowtype = 160) THEN -- Planned Make
3774: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3775: ' AND order_type = 5 ';
3776: ELSIF (l_isDrp = true AND p_rowtype = 170) THEN -- Ext Supply
3777: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3778: ' AND order_type in (1,2) ';
3779:
3780: ELSIF (l_isDrp = true AND p_rowtype = 220) THEN
3781: -- Arrivals := planned inbound shipment + IR

Line 3782: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3778: ' AND order_type in (1,2) ';
3779:
3780: ELSIF (l_isDrp = true AND p_rowtype = 220) THEN
3781: -- Arrivals := planned inbound shipment + IR
3782: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3783: ' AND order_type in (51,53) ';
3784: ELSIF (l_isDrp = true AND p_rowtype = 380) THEN -- Req. Arrivals
3785: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3786: ' AND order_type = 52 ';

Line 3785: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

3781: -- Arrivals := planned inbound shipment + IR
3782: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3783: ' AND order_type in (51,53) ';
3784: ELSIF (l_isDrp = true AND p_rowtype = 380) THEN -- Req. Arrivals
3785: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3786: ' AND order_type = 52 ';
3787: ELSIF (l_isDrp = true AND p_rowtype = 80) THEN
3788: -- Requested Shipments
3789: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

Line 3797: sql_stmt := sql_stmt || ' AND ((source_table = ''MSC_SUPPLIES'''||

3793: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3794: ' AND order_type in (53,54) ';
3795: ELSIF l_isDrp = true AND p_rowtype in (280, 290, 300 ) then -- poh, pab
3796: if p_rowtype = 280 then -- POH
3797: sql_stmt := sql_stmt || ' AND ((source_table = ''MSC_SUPPLIES'''||
3798: ' AND order_type in (1,2,3,7,8,11,12,14,15,17,18,27,28,32,49,53)) ';
3799: else
3800: sql_stmt := sql_stmt || ' AND ((source_table = ''MSC_SUPPLIES'''||
3801: ' AND order_type in (1,2,3,5,7,8,11,12,14,15,17,18,27,28,29,32,49,51,53)) ';

Line 3800: sql_stmt := sql_stmt || ' AND ((source_table = ''MSC_SUPPLIES'''||

3796: if p_rowtype = 280 then -- POH
3797: sql_stmt := sql_stmt || ' AND ((source_table = ''MSC_SUPPLIES'''||
3798: ' AND order_type in (1,2,3,7,8,11,12,14,15,17,18,27,28,32,49,53)) ';
3799: else
3800: sql_stmt := sql_stmt || ' AND ((source_table = ''MSC_SUPPLIES'''||
3801: ' AND order_type in (1,2,3,5,7,8,11,12,14,15,17,18,27,28,29,32,49,51,53)) ';
3802: end if;
3803: sql_stmt := sql_stmt ||
3804: ' OR (source_table = ''MSC_DEMANDS'' AND ';