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_DEMANDS

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 604: msc_demands mgr,

600: 0 dos,
601: 0 cost
602: FROM msc_form_query list,
603: msc_trading_partners param,
604: msc_demands mgr,
605: msc_calendar_dates dates
606: WHERE (arg_res_level = 1
607: OR (arg_res_level = 2
608: AND mgr.project_id is NULL)

Line 740: msc_demands mgr,

736: 0 dos,
737: 0 cost
738: FROM msc_form_query list,
739: msc_trading_partners param,
740: msc_demands mgr,
741: msc_calendar_dates dates
742: WHERE (arg_res_level = 1
743: OR (arg_res_level = 2
744: AND mgr.project_id is NULL)

Line 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' ;

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' ;
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' ;

Line 3641: sql_stmt := sql_stmt || sql_stmt_4|| ' AND source_table = ''MSC_DEMANDS''' ||'AND order_type =1 AND item_type_value = 2' ;

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:
3644: ELSE
3645:

Line 3656: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3652: END IF;
3653:
3654: IF((l_isHp = true AND p_rowtype in (10,230)) OR -- Sales orders
3655: (l_isDrp = true AND p_rowtype = 20)) THEN
3656: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3657: ' AND order_type in (6,30) ';
3658: ELSIF ((l_isHp = true AND p_rowtype in (20,210,270,290,300)) OR -- Forecast, MAD
3659: (l_isDrp = true AND p_rowtype = 30)) THEN
3660: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

Line 3660: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3656: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3657: ' AND order_type in (6,30) ';
3658: ELSIF ((l_isHp = true AND p_rowtype in (20,210,270,290,300)) OR -- Forecast, MAD
3659: (l_isDrp = true AND p_rowtype = 30)) THEN
3660: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3661: ' AND order_type in (7,29)';
3662: ELSIF (l_isHp = true AND p_rowtype = 30) THEN -- Dependent demand
3663: sql_stmt := sql_stmt ||
3664: ' AND source_table = ''MSC_DEMANDS'''||

Line 3664: ' AND source_table = ''MSC_DEMANDS'''||

3660: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3661: ' AND order_type in (7,29)';
3662: ELSIF (l_isHp = true AND p_rowtype = 30) THEN -- Dependent demand
3663: sql_stmt := sql_stmt ||
3664: ' AND source_table = ''MSC_DEMANDS'''||
3665: ' AND order_type in (1,2,3,4,22,24,25) AND item_type_value = 1';
3666: ELSIF (l_isHp = true AND p_rowtype = 335) THEN -- Maintenance WO demand /*Added for bug#12651354 */
3667: sql_stmt := sql_stmt ||
3668: ' AND source_table = ''MSC_DEMANDS'''||

Line 3668: ' AND source_table = ''MSC_DEMANDS'''||

3664: ' AND source_table = ''MSC_DEMANDS'''||
3665: ' AND order_type in (1,2,3,4,22,24,25) AND item_type_value = 1';
3666: ELSIF (l_isHp = true AND p_rowtype = 335) THEN -- Maintenance WO demand /*Added for bug#12651354 */
3667: sql_stmt := sql_stmt ||
3668: ' AND source_table = ''MSC_DEMANDS'''||
3669: ' AND order_type in (50,92) ';
3670: ELSIF (l_isHp = true AND p_rowtype = 40) THEN -- Expected scrap
3671: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3672: ' AND order_type in (16,17,18,19,20,21,23,26) ';

Line 3671: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3667: sql_stmt := sql_stmt ||
3668: ' AND source_table = ''MSC_DEMANDS'''||
3669: ' AND order_type in (50,92) ';
3670: ELSIF (l_isHp = true AND p_rowtype = 40) THEN -- Expected scrap
3671: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3672: ' AND order_type in (16,17,18,19,20,21,23,26) ';
3673:
3674: ELSIF (l_isHp = true AND p_rowtype = 45) THEN -- Payback Demand
3675: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

Line 3675: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3671: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3672: ' AND order_type in (16,17,18,19,20,21,23,26) ';
3673:
3674: ELSIF (l_isHp = true AND p_rowtype = 45) THEN -- Payback Demand
3675: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3676: ' AND order_type = 27 ';
3677: ELSIF (l_isHp = true AND p_rowtype = 50) THEN -- Other independent demand
3678: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3679: ' AND order_type in (5,8,9,10,11,12,15) AND item_type_value = 1';

Line 3678: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3674: ELSIF (l_isHp = true AND p_rowtype = 45) THEN -- Payback Demand
3675: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3676: ' AND order_type = 27 ';
3677: ELSIF (l_isHp = true AND p_rowtype = 50) THEN -- Other independent demand
3678: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3679: ' AND order_type in (5,8,9,10,11,12,15) AND item_type_value = 1';
3680: ELSIF (l_isDRP = true AND p_rowtype = 60) THEN -- Other demand
3681: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3682: ' AND order_type in (5,8,9,10,11,12,15,16,17,18,19,20,23) ';

Line 3681: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3677: ELSIF (l_isHp = true AND p_rowtype = 50) THEN -- Other independent demand
3678: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3679: ' AND order_type in (5,8,9,10,11,12,15) AND item_type_value = 1';
3680: ELSIF (l_isDRP = true AND p_rowtype = 60) THEN -- Other demand
3681: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3682: ' AND order_type in (5,8,9,10,11,12,15,16,17,18,19,20,23) ';
3683: ELSIF (p_rowtype = 70) THEN --Gross requirements
3684: sql_stmt := sql_stmt ||
3685: ' AND source_table = ''MSC_DEMANDS'''||' AND item_type_value = 1 ';

Line 3685: ' AND source_table = ''MSC_DEMANDS'''||' AND item_type_value = 1 ';

3681: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3682: ' AND order_type in (5,8,9,10,11,12,15,16,17,18,19,20,23) ';
3683: ELSIF (p_rowtype = 70) THEN --Gross requirements
3684: sql_stmt := sql_stmt ||
3685: ' AND source_table = ''MSC_DEMANDS'''||' AND item_type_value = 1 ';
3686: if l_isDrp then -- not include unconstr kit demand/request shipment
3687: sql_stmt := sql_stmt ||
3688: ' AND order_type not in (48,49) ';
3689: end if;

Line 3692: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3688: ' AND order_type not in (48,49) ';
3689: end if;
3690: ELSIF (l_isHp = true AND p_rowtype = 160) or
3691: (l_isDRP = true AND p_rowtype = 370) THEN -- expired lot
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''' ||

Line 3750: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3746: -- New Row Types added for DRP
3747: -- ---------------------------
3748:
3749: ELSIF (l_isDrp = true AND p_rowtype = 10) THEN -- External Demand
3750: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3751: ' AND order_type in (6,7,29,30) ';
3752: ELSIF (l_isDrp = true AND p_rowtype = 40) THEN
3753: -- Kit Demand = constrained kit demand + discrete job demand
3754: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

Line 3754: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3750: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3751: ' AND order_type in (6,7,29,30) ';
3752: ELSIF (l_isDrp = true AND p_rowtype = 40) THEN
3753: -- Kit Demand = constrained kit demand + discrete job demand
3754: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3755: ' AND order_type in (3,47) ';
3756: ELSIF (l_isDrp = true AND p_rowtype = 90) THEN
3757: -- UnConstnd. Kit Demand = discrete job dmd + unconst. kit dmd
3758: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

Line 3758: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3754: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3755: ' AND order_type in (3,47) ';
3756: ELSIF (l_isDrp = true AND p_rowtype = 90) THEN
3757: -- UnConstnd. Kit Demand = discrete job dmd + unconst. kit dmd
3758: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3759: ' AND order_type in (3,48) ';
3760:
3761: ELSIF (l_isDrp = true AND p_rowtype = 100) THEN
3762: -- UnConstnd. Other Demand: scrap dmd + interorg demand

Line 3763: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3759: ' AND order_type in (3,48) ';
3760:
3761: ELSIF (l_isDrp = true AND p_rowtype = 100) THEN
3762: -- UnConstnd. Other Demand: scrap dmd + interorg demand
3763: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3764: ' AND order_type in (16,17,18,19,20,23,24) ';
3765: ELSIF (l_isDrp = true AND p_rowtype = 110) THEN
3766: -- UnConstnd. Total Demand= ext SO +FC + req shipment + unc kit +unc other dmd
3767: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

Line 3767: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3763: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3764: ' AND order_type in (16,17,18,19,20,23,24) ';
3765: ELSIF (l_isDrp = true AND p_rowtype = 110) THEN
3766: -- UnConstnd. Total Demand= ext SO +FC + req shipment + unc kit +unc other dmd
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''' ||

Line 3789: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

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''' ||
3790: ' AND order_type = 49 ';
3791: ELSIF (l_isDrp = true AND p_rowtype = 50) THEN
3792: -- Shipments = planned outbound shipment + ISO
3793: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

Line 3793: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3789: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3790: ' AND order_type = 49 ';
3791: ELSIF (l_isDrp = true AND p_rowtype = 50) THEN
3792: -- Shipments = planned outbound shipment + ISO
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'''||

Line 3804: ' OR (source_table = ''MSC_DEMANDS'' AND ';

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 ';
3805: if p_rowtype in (280, 290) then -- poh, pab
3806: -- show const. total demand, not include unc kit dmd/request shipment
3807: sql_stmt := sql_stmt ||
3808: ' order_type not in (48,49) )) ';

Line 3817: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

3813: end if;
3814:
3815:
3816: ELSIF (l_isDrp = true AND p_rowtype = 390) THEN -- Expired Demand
3817: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3818: ' AND order_type in (6,29,30) ' ||
3819: ' and unmet_quantity > 0 ';
3820:
3821: END IF;