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 312: -- MSC_DEMANDS and MSC_SUPPLIES

308: l_plan_type NUMBER := 1;
309:
310: -- --------------------------------------------
311: -- This cursor selects the snapshot activity in
312: -- MSC_DEMANDS and MSC_SUPPLIES
313: -- for the items per organizatio for a plan..
314: -- --------------------------------------------
315: CURSOR mrp_snapshot_activity IS
316: SELECT /*+ INDEX(rec, MSC_SUPPLIES_N1) */

Line 535: msc_demands mgr,

531: 0 dos,
532: 0 cost
533: FROM msc_form_query list,
534: msc_trading_partners param,
535: msc_demands mgr,
536: msc_calendar_dates dates
537: WHERE (arg_res_level = 1
538: OR (arg_res_level = 2
539: AND mgr.project_id is NULL)

Line 662: msc_demands mgr,

658: 0 dos,
659: 0 cost
660: FROM msc_form_query list,
661: msc_trading_partners param,
662: msc_demands mgr,
663: msc_calendar_dates dates
664: WHERE (arg_res_level = 1
665: OR (arg_res_level = 2
666: AND mgr.project_id is NULL)

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

3414: END IF;
3415:
3416: IF((l_isHp = true AND p_rowtype in (10,230)) OR -- Sales orders
3417: (l_isDrp = true AND p_rowtype = 20)) THEN
3418: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3419: ' AND order_type in (6,30) ';
3420: ELSIF ((l_isHp = true AND p_rowtype in (20,210,270,290,300)) OR -- Forecast, MAD
3421: (l_isDrp = true AND p_rowtype = 30)) THEN
3422: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

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

3418: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3419: ' AND order_type in (6,30) ';
3420: ELSIF ((l_isHp = true AND p_rowtype in (20,210,270,290,300)) OR -- Forecast, MAD
3421: (l_isDrp = true AND p_rowtype = 30)) THEN
3422: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3423: ' AND order_type in (7,29)';
3424: ELSIF (l_isHp = true AND p_rowtype = 30) THEN -- Dependent demand
3425: sql_stmt := sql_stmt ||
3426: ' AND source_table = ''MSC_DEMANDS'''||

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

3422: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3423: ' AND order_type in (7,29)';
3424: ELSIF (l_isHp = true AND p_rowtype = 30) THEN -- Dependent demand
3425: sql_stmt := sql_stmt ||
3426: ' AND source_table = ''MSC_DEMANDS'''||
3427: ' AND order_type in (1,2,3,4,22,24,25) ';
3428: ELSIF (l_isHp = true AND p_rowtype = 40) THEN -- Expected scrap
3429: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3430: ' AND order_type in (16,17,18,19,20,21,23,26) ';

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

3425: sql_stmt := sql_stmt ||
3426: ' AND source_table = ''MSC_DEMANDS'''||
3427: ' AND order_type in (1,2,3,4,22,24,25) ';
3428: ELSIF (l_isHp = true AND p_rowtype = 40) THEN -- Expected scrap
3429: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3430: ' AND order_type in (16,17,18,19,20,21,23,26) ';
3431:
3432: ELSIF (l_isHp = true AND p_rowtype = 45) THEN -- Payback Demand
3433: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

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

3429: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3430: ' AND order_type in (16,17,18,19,20,21,23,26) ';
3431:
3432: ELSIF (l_isHp = true AND p_rowtype = 45) THEN -- Payback Demand
3433: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3434: ' AND order_type = 27 ';
3435: ELSIF (l_isHp = true AND p_rowtype = 50) THEN -- Other independent demand
3436: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3437: ' AND order_type in (5,8,9,10,11,12,15) ';

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

3432: ELSIF (l_isHp = true AND p_rowtype = 45) THEN -- Payback Demand
3433: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3434: ' AND order_type = 27 ';
3435: ELSIF (l_isHp = true AND p_rowtype = 50) THEN -- Other independent demand
3436: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3437: ' AND order_type in (5,8,9,10,11,12,15) ';
3438: ELSIF (l_isDRP = true AND p_rowtype = 60) THEN -- Other demand
3439: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3440: ' AND order_type in (5,8,9,10,11,12,15,16,17,18,19,20,23) ';

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

3435: ELSIF (l_isHp = true AND p_rowtype = 50) THEN -- Other independent demand
3436: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3437: ' AND order_type in (5,8,9,10,11,12,15) ';
3438: ELSIF (l_isDRP = true AND p_rowtype = 60) THEN -- Other demand
3439: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3440: ' AND order_type in (5,8,9,10,11,12,15,16,17,18,19,20,23) ';
3441: ELSIF (p_rowtype = 70) THEN --Gross requirements
3442: sql_stmt := sql_stmt ||
3443: ' AND source_table = ''MSC_DEMANDS''';

Line 3443: ' AND source_table = ''MSC_DEMANDS''';

3439: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3440: ' AND order_type in (5,8,9,10,11,12,15,16,17,18,19,20,23) ';
3441: ELSIF (p_rowtype = 70) THEN --Gross requirements
3442: sql_stmt := sql_stmt ||
3443: ' AND source_table = ''MSC_DEMANDS''';
3444: if l_isDrp then -- not include unconstr kit demand/request shipment
3445: sql_stmt := sql_stmt ||
3446: ' AND order_type not in (48,49) ';
3447: end if;

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

3446: ' AND order_type not in (48,49) ';
3447: end if;
3448: ELSIF (l_isHp = true AND p_rowtype = 160) or
3449: (l_isDRP = true AND p_rowtype = 370) THEN -- expired lot
3450: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3451: ' AND order_type =5 ';
3452: ELSIF ((l_isHp = true AND p_rowtype = 81) OR -- WIP
3453: (l_isDrp = true AND p_rowtype = 140)) THEN
3454: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

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

3504: -- New Row Types added for DRP
3505: -- ---------------------------
3506:
3507: ELSIF (l_isDrp = true AND p_rowtype = 10) THEN -- External Demand
3508: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3509: ' AND order_type in (6,7,29,30) ';
3510: ELSIF (l_isDrp = true AND p_rowtype = 40) THEN
3511: -- Kit Demand = constrained kit demand + discrete job demand
3512: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

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

3508: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3509: ' AND order_type in (6,7,29,30) ';
3510: ELSIF (l_isDrp = true AND p_rowtype = 40) THEN
3511: -- Kit Demand = constrained kit demand + discrete job demand
3512: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3513: ' AND order_type in (3,47) ';
3514: ELSIF (l_isDrp = true AND p_rowtype = 90) THEN
3515: -- UnConstnd. Kit Demand = discrete job dmd + unconst. kit dmd
3516: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

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

3512: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3513: ' AND order_type in (3,47) ';
3514: ELSIF (l_isDrp = true AND p_rowtype = 90) THEN
3515: -- UnConstnd. Kit Demand = discrete job dmd + unconst. kit dmd
3516: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3517: ' AND order_type in (3,48) ';
3518:
3519: ELSIF (l_isDrp = true AND p_rowtype = 100) THEN
3520: -- UnConstnd. Other Demand: scrap dmd + interorg demand

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

3517: ' AND order_type in (3,48) ';
3518:
3519: ELSIF (l_isDrp = true AND p_rowtype = 100) THEN
3520: -- UnConstnd. Other Demand: scrap dmd + interorg demand
3521: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3522: ' AND order_type in (16,17,18,19,20,23,24) ';
3523: ELSIF (l_isDrp = true AND p_rowtype = 110) THEN
3524: -- UnConstnd. Total Demand= ext SO +FC + req shipment + unc kit +unc other dmd
3525: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

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

3521: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3522: ' AND order_type in (16,17,18,19,20,23,24) ';
3523: ELSIF (l_isDrp = true AND p_rowtype = 110) THEN
3524: -- UnConstnd. Total Demand= ext SO +FC + req shipment + unc kit +unc other dmd
3525: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3526: ' AND order_type in (30,29,49,3,48,16,17,18,19,20,23) ';
3527:
3528: ELSIF (l_isDrp = true AND p_rowtype = 120) THEN -- Internal Supply
3529: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||

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

3543: sql_stmt := sql_stmt || ' AND source_table = ''MSC_SUPPLIES''' ||
3544: ' AND order_type = 52 ';
3545: ELSIF (l_isDrp = true AND p_rowtype = 80) THEN
3546: -- Requested Shipments
3547: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3548: ' AND order_type = 49 ';
3549: ELSIF (l_isDrp = true AND p_rowtype = 50) THEN
3550: -- Shipments = planned outbound shipment + ISO
3551: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||

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

3547: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3548: ' AND order_type = 49 ';
3549: ELSIF (l_isDrp = true AND p_rowtype = 50) THEN
3550: -- Shipments = planned outbound shipment + ISO
3551: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3552: ' AND order_type in (53,54) ';
3553: ELSIF l_isDrp = true AND p_rowtype in (280, 290, 300 ) then -- poh, pab
3554: if p_rowtype = 280 then -- POH
3555: sql_stmt := sql_stmt || ' AND ((source_table = ''MSC_SUPPLIES'''||

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

3558: sql_stmt := sql_stmt || ' AND ((source_table = ''MSC_SUPPLIES'''||
3559: ' AND order_type in (1,2,3,5,7,8,11,12,14,15,17,18,27,28,29,32,49,51,53)) ';
3560: end if;
3561: sql_stmt := sql_stmt ||
3562: ' OR (source_table = ''MSC_DEMANDS'' AND ';
3563: if p_rowtype in (280, 290) then -- poh, pab
3564: -- show const. total demand, not include unc kit dmd/request shipment
3565: sql_stmt := sql_stmt ||
3566: ' order_type not in (48,49) )) ';

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

3571: end if;
3572:
3573:
3574: ELSIF (l_isDrp = true AND p_rowtype = 390) THEN -- Expired Demand
3575: sql_stmt := sql_stmt || ' AND source_table = ''MSC_DEMANDS''' ||
3576: ' AND order_type in (6,29,30) ' ||
3577: ' and unmet_quantity > 0 ';
3578:
3579: END IF;