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_GET_GANTT_DATA dependencies on MSC_RESOURCE_REQUIREMENTS

Line 189: from msc_resource_requirements mrr,

185: ms.firm_planned_type sup_firm_flag,
186: decode(sign(ms.new_schedule_date - (ms.need_by_date+1)), 1,
187: 1,0) late_flag,
188: mrr.supply_id
189: from msc_resource_requirements mrr,
190: msc_supplies ms,
191: msc_items msi,
192: mfg_lookups mfg
193: where mrr.organization_id =v_org_id

Line 247: from msc_resource_requirements mrr,

243: ms.firm_planned_type sup_firm_flag,
244: decode(sign(ms.new_schedule_date - (ms.need_by_date+1)), 1,
245: 1,0) late_flag,
246: mrr.supply_id
247: from msc_resource_requirements mrr,
248: msc_supplies ms,
249: msc_items msi,
250: mfg_lookups mfg,
251: msc_form_query mfq

Line 606: from msc_resource_requirements

602: nvl(firm_end_date, end_date))) end_date,
603: assigned_units,
604: nvl(overloaded_capacity,0) over_cap,
605: batch_number
606: from msc_resource_requirements
607: where organization_id =v_org_id
608: and sr_instance_id = v_instance_id
609: and department_id = v_dept_id
610: and resource_id = v_res_id

Line 647: from msc_resource_requirements mrr,

643: ) end_date,
644: mrr2.resource_hours assigned_units,
645: -1 over_cap,
646: mrr2.batch_number
647: from msc_resource_requirements mrr,
648: msc_resource_requirements mrr2
649: where mrr.organization_id =v_org_id
650: and mrr.sr_instance_id = v_instance_id
651: and mrr.department_id = v_dept_id

Line 648: msc_resource_requirements mrr2

644: mrr2.resource_hours assigned_units,
645: -1 over_cap,
646: mrr2.batch_number
647: from msc_resource_requirements mrr,
648: msc_resource_requirements mrr2
649: where mrr.organization_id =v_org_id
650: and mrr.sr_instance_id = v_instance_id
651: and mrr.department_id = v_dept_id
652: and mrr.resource_id = v_res_id

Line 699: from msc_resource_requirements mrr,

695: )) end_date,
696: max(mrr2.resource_hours) assigned_units,
697: -1 over_cap,
698: mrr2.batch_number
699: from msc_resource_requirements mrr,
700: msc_resource_requirements mrr2
701: where mrr.organization_id =v_org_id
702: and mrr.sr_instance_id = v_instance_id
703: and mrr.department_id = v_dept_id

Line 700: msc_resource_requirements mrr2

696: max(mrr2.resource_hours) assigned_units,
697: -1 over_cap,
698: mrr2.batch_number
699: from msc_resource_requirements mrr,
700: msc_resource_requirements mrr2
701: where mrr.organization_id =v_org_id
702: and mrr.sr_instance_id = v_instance_id
703: and mrr.department_id = v_dept_id
704: and mrr.resource_id = v_res_id

Line 764: from msc_resource_requirements

760: nvl(firm_end_date, end_date)))) end_date,
761: max(assigned_units) assigned_units,
762: max(nvl(overloaded_capacity,0)) over_cap
763: , batch_number
764: from msc_resource_requirements
765: where organization_id =v_org_id
766: and sr_instance_id = v_instance_id
767: and department_id = v_dept_id
768: and resource_id = v_res_id

Line 1140: FROM msc_resource_requirements mrr,

1136: ;
1137:
1138: CURSOR res_group IS
1139: SELECT distinct mrr.transaction_id,mor.principal_flag
1140: FROM msc_resource_requirements mrr,
1141: msc_operation_resources mor
1142: WHERE mrr.plan_id = p_plan_id
1143: AND mrr.sr_instance_id = p_instance_id
1144: and mrr.routing_sequence_id = l_rout_seq

Line 1202: FROM msc_resource_requirements mrr

1198: mrr.routing_sequence_id, mrr.operation_sequence_id,
1199: mrr.resource_seq_num,mrr.supply_id,mrr.basis_type
1200: into
1201: l_rout_seq, l_op_seq, l_res_seq, l_supply_id,l_basis_type
1202: FROM msc_resource_requirements mrr
1203: WHERE mrr.plan_id = p_plan_id
1204: and mrr.transaction_id = p_transaction_id
1205: and mrr.sr_instance_id = p_instance_id;
1206:

Line 1292: insert into msc_resource_requirements(

1288: if i > l_simu_res.LAST THEN -- add the res from alt res group
1289:
1290: v_hours := v_qty * l_alt_res(i).resource_usage;
1291:
1292: insert into msc_resource_requirements(
1293: TRANSACTION_ID ,
1294: PLAN_ID ,
1295: SUPPLY_ID ,
1296: ORGANIZATION_ID ,

Line 1337: select msc_resource_requirements_s.nextval,

1333: SUPPLY_TYPE ,
1334: FIRM_START_DATE ,
1335: FIRM_END_DATE ,
1336: FIRM_FLAG )
1337: select msc_resource_requirements_s.nextval,
1338: PLAN_ID ,
1339: SUPPLY_ID ,
1340: ORGANIZATION_ID ,
1341: SR_INSTANCE_ID ,

Line 1381: from msc_resource_requirements mrr

1377: SUPPLY_TYPE ,
1378: FIRM_START_DATE ,
1379: FIRM_END_DATE ,
1380: FIRM_RESOURCE
1381: from msc_resource_requirements mrr
1382: WHERE mrr.plan_id = p_plan_id
1383: and mrr.transaction_id = l_simu_res(1).transaction_id
1384: and mrr.sr_instance_id = p_instance_id;
1385:

Line 1389: FROM msc_resource_requirements mrr

1385:
1386: ELSIF i > l_alt_res.LAST THEN -- delete the extra res
1387: select mrr.firm_flag
1388: into l_firm_flag
1389: FROM msc_resource_requirements mrr
1390: WHERE mrr.plan_id = p_plan_id
1391: and mrr.transaction_id = l_simu_res(i).transaction_id
1392: and mrr.sr_instance_id = p_instance_id
1393: for update of mrr.firm_flag nowait;

Line 1394: delete msc_resource_requirements mrr

1390: WHERE mrr.plan_id = p_plan_id
1391: and mrr.transaction_id = l_simu_res(i).transaction_id
1392: and mrr.sr_instance_id = p_instance_id
1393: for update of mrr.firm_flag nowait;
1394: delete msc_resource_requirements mrr
1395: where mrr.plan_id = p_plan_id
1396: and mrr.transaction_id = l_simu_res(i).transaction_id
1397: and mrr.sr_instance_id = p_instance_id;
1398:

Line 1403: FROM msc_resource_requirements mrr

1399: ELSE -- update the res to alt_res
1400:
1401: select mrr.firm_flag
1402: into l_firm_flag
1403: FROM msc_resource_requirements mrr
1404: WHERE mrr.plan_id = p_plan_id
1405: and mrr.transaction_id = l_simu_res(i).transaction_id
1406: and mrr.sr_instance_id = p_instance_id
1407: for update of mrr.firm_flag nowait;

Line 1427: update msc_resource_requirements

1423: -- l_alt_res(i).resource_id,
1424: -- l_alt_res(i).alternate_number,
1425: -- v_hours);
1426: v_hours := v_qty * l_alt_res(i).resource_usage;
1427: update msc_resource_requirements
1428: set status =0,
1429: applied=2,
1430: resource_id = l_alt_res(i).resource_id,
1431: alternate_num = l_alt_res(i).alternate_number,

Line 1479: FROM msc_resource_requirements mrr1,

1475: l_end date;
1476:
1477: CURSOR simu IS
1478: SELECT mrr2.transaction_id, mrr2.sr_instance_id
1479: FROM msc_resource_requirements mrr1,
1480: msc_resource_requirements mrr2
1481: WHERE mrr1.plan_id = p_plan_id
1482: and mrr1.transaction_id = p_transaction_id
1483: and mrr1.sr_instance_id = p_instance_id

Line 1480: msc_resource_requirements mrr2

1476:
1477: CURSOR simu IS
1478: SELECT mrr2.transaction_id, mrr2.sr_instance_id
1479: FROM msc_resource_requirements mrr1,
1480: msc_resource_requirements mrr2
1481: WHERE mrr1.plan_id = p_plan_id
1482: and mrr1.transaction_id = p_transaction_id
1483: and mrr1.sr_instance_id = p_instance_id
1484: and mrr2.plan_id = mrr1.plan_id

Line 1520: FROM msc_resource_requirements mrr

1516: mrr.start_date, mrr.end_date
1517: into l_firm_flag, l_firm_start, l_firm_end,
1518: l_res_id, l_alt_num, l_supply_id,
1519: l_start, l_end
1520: FROM msc_resource_requirements mrr
1521: WHERE mrr.plan_id = p_plan_id
1522: and mrr.transaction_id = p_transaction_id
1523: and mrr.sr_instance_id = p_instance_id
1524: for update of mrr.firm_flag nowait;

Line 1548: update msc_resource_requirements

1544: --undo_change(p_plan_id, p_transaction_id, p_instance_id,
1545: -- p_firm_type, l_firm_start, l_firm_end,
1546: -- l_res_id, l_alt_num);
1547:
1548: update msc_resource_requirements
1549: set status =0,
1550: applied=2,
1551: firm_flag = p_firm_type,
1552: firm_start_date = l_firm_start,

Line 1574: FROM msc_resource_requirements mrr

1570: EXIT WHEN simu%NOTFOUND;
1571:
1572: select mrr.resource_id, mrr.alternate_num
1573: into l_res_id, l_alt_num
1574: FROM msc_resource_requirements mrr
1575: WHERE mrr.plan_id = p_plan_id
1576: and mrr.transaction_id = v_transaction_id
1577: and mrr.sr_instance_id = v_instance_id
1578: for update of mrr.firm_flag nowait;

Line 1584: update msc_resource_requirements

1580: --undo_change(p_plan_id, v_transaction_id, v_instance_id,
1581: -- p_firm_type, l_firm_start, l_firm_end,
1582: -- l_res_id, l_alt_num);
1583:
1584: update msc_resource_requirements
1585: set status =0,
1586: applied=2,
1587: firm_flag = p_firm_type,
1588: firm_start_date = l_firm_start,

Line 1622: msc_resource_requirements mrr

1618: mrr.sr_instance_id),
1619: mor.resource_id,
1620: mor.alternate_number
1621: FROM msc_operation_resources mor,
1622: msc_resource_requirements mrr
1623: WHERE mrr.plan_id = p_plan_id
1624: AND mrr.transaction_id = p_transaction_id
1625: AND mrr.sr_instance_id = p_instance_id
1626: AND mor.plan_id = mrr.plan_id

Line 1635: FROM msc_resource_requirements mrr

1631: AND mor.alternate_number <> mrr.alternate_num;
1632:
1633: CURSOR flag IS
1634: SELECT nvl(mrr.firm_flag,NO_FIRM)
1635: FROM msc_resource_requirements mrr
1636: WHERE mrr.plan_id = p_plan_id
1637: AND mrr.transaction_id = p_transaction_id
1638: AND mrr.sr_instance_id = p_instance_id;
1639:

Line 1645: msc_resource_requirements mrr

1641: select mors.activity_group_id,
1642: mrr.routing_sequence_id, mrr.operation_sequence_id,
1643: mrr.resource_seq_num
1644: from msc_operation_resource_seqs mors,
1645: msc_resource_requirements mrr
1646: where mrr.plan_id = p_plan_id
1647: and mrr.transaction_id = p_transaction_id
1648: and mrr.sr_instance_id = p_instance_id
1649: and mors.plan_id = mrr.plan_id

Line 1758: msc_resource_requirements mrr

1754: mrr.organization_id, mrr.plan_id,
1755: mrr.sr_instance_id),
1756: mor.resource_id
1757: FROM msc_operation_resources mor,
1758: msc_resource_requirements mrr
1759: WHERE mrr.plan_id = p_plan_id
1760: AND mrr.transaction_id = p_transaction_id
1761: AND mrr.sr_instance_id = p_instance_id
1762: AND mor.plan_id = mrr.plan_id

Line 1859: msc_resource_requirements mrr,

1855: nvl(to_char(mrr.UEPCD,format_mask),'null') UEPCD,
1856: nvl(to_char(mrr.ULPSD,format_mask),'null') ULPSD,
1857: nvl(to_char(mrr.ULPCD,format_mask),'null') ULPCD
1858: FROM msc_supplies ms,
1859: msc_resource_requirements mrr,
1860: msc_department_resources mdr,
1861: msc_system_items msi,
1862: msc_process_effectivity pe
1863: WHERE pe.plan_id(+) = ms.plan_id

Line 2158: from msc_resource_requirements mrr

2154: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
2155: mrr.assigned_units,
2156: mrr.transaction_id,
2157: mrr.sr_instance_id
2158: from msc_resource_requirements mrr
2159: where mrr.sr_instance_id = p_instance_id
2160: and mrr.plan_id = p_plan_id
2161: and mrr.organization_id = p_org_id
2162: and mrr.end_date is not null

Line 2256: from msc_resource_requirements mrr

2252: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
2253: mrr.assigned_units,
2254: mrr.transaction_id,
2255: mrr.sr_instance_id
2256: from msc_resource_requirements mrr
2257: where mrr.sr_instance_id = p_instance_id
2258: and mrr.plan_id = p_plan_id
2259: and mrr.transaction_id = p_transaction_id
2260: and mrr.end_date is not null

Line 2369: msc_resource_requirements mrr,

2365: select mro.MINIMUM_TRANSFER_QUANTITY,
2366: mrr.cummulative_quantity, ms.new_order_quantity
2367: into l_mtq,l_cumm_quan, l_order_quan
2368: from msc_routing_operations mro,
2369: msc_resource_requirements mrr,
2370: msc_supplies ms
2371: where mrr.plan_id = p_plan_id
2372: and mrr.sr_instance_id = p_instance_id
2373: and mrr.transaction_id = p_transaction_id

Line 2414: FROM msc_resource_requirements mrr,

2410: decode(ms.order_type, 27,
2411: 1, ms.firm_planned_type) firm_planned_type,
2412: sysdate theDate,
2413: get_MTQ_time(p_transaction_id, p_plan_id, p_instance_id) mtq_time
2414: FROM msc_resource_requirements mrr,
2415: msc_supplies ms
2416: WHERE mrr.plan_id = p_plan_id
2417: and mrr.transaction_id = p_transaction_id
2418: and mrr.sr_instance_id = p_instance_id

Line 2447: from msc_resource_requirements mrr1,

2443: mrr2.firm_start_date + (nvl(mrr2.end_date, mrr2.start_date+mrr2.resource_hours/24)
2444: - mrr2.start_date),
2445: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date,
2446: get_MTQ_time(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
2447: from msc_resource_requirements mrr1,
2448: msc_resource_requirements mrr2,
2449: msc_routings mr
2450: where mrr1.plan_id = p_plan_id
2451: and mrr1.transaction_id = p_transaction_id

Line 2448: msc_resource_requirements mrr2,

2444: - mrr2.start_date),
2445: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date,
2446: get_MTQ_time(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
2447: from msc_resource_requirements mrr1,
2448: msc_resource_requirements mrr2,
2449: msc_routings mr
2450: where mrr1.plan_id = p_plan_id
2451: and mrr1.transaction_id = p_transaction_id
2452: and mrr1.sr_instance_id = p_instance_id

Line 2499: from msc_resource_requirements mrr1,

2495: FIRM_START_RES,
2496: mrr2.firm_start_date + (nvl(mrr2.end_date, mrr2.start_date+mrr2.resource_hours/24)
2497: - mrr2.start_date),
2498: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date
2499: from msc_resource_requirements mrr1,
2500: msc_resource_requirements mrr2,
2501: msc_routings mr
2502: where mrr1.plan_id = p_plan_id
2503: and mrr1.transaction_id = p_transaction_id

Line 2500: msc_resource_requirements mrr2,

2496: mrr2.firm_start_date + (nvl(mrr2.end_date, mrr2.start_date+mrr2.resource_hours/24)
2497: - mrr2.start_date),
2498: nvl(nvl(mrr2.firm_end_date, mrr2.end_date), mrr2.start_date+mrr2.resource_hours/24)) end_date
2499: from msc_resource_requirements mrr1,
2500: msc_resource_requirements mrr2,
2501: msc_routings mr
2502: where mrr1.plan_id = p_plan_id
2503: and mrr1.transaction_id = p_transaction_id
2504: and mrr1.sr_instance_id = p_instance_id

Line 2711: msc_resource_requirements mrr,

2707: nvl(mrr.firm_start_date, mrr.start_date)),
2708: msi.PLANNING_TIME_FENCE_DATE
2709: into l_prev_start_date, l_timefence_date
2710: from msc_system_items msi,
2711: msc_resource_requirements mrr,
2712: msc_supplies ms
2713: where mrr.plan_id = p_plan_id
2714: and mrr.transaction_id = p_transaction_id
2715: and mrr.sr_instance_id = p_instance_id

Line 2744: FROM msc_resource_requirements mrr1,

2740: p_out OUT NOCOPY varchar2,
2741: p_out2 OUT NOCOPY boolean) IS
2742: CURSOR simu IS
2743: SELECT mrr2.transaction_id, mrr2.sr_instance_id
2744: FROM msc_resource_requirements mrr1,
2745: msc_resource_requirements mrr2
2746: WHERE mrr1.plan_id = p_plan_id
2747: and mrr1.transaction_id = p_transaction_id
2748: and mrr1.sr_instance_id = p_instance_id

Line 2745: msc_resource_requirements mrr2

2741: p_out2 OUT NOCOPY boolean) IS
2742: CURSOR simu IS
2743: SELECT mrr2.transaction_id, mrr2.sr_instance_id
2744: FROM msc_resource_requirements mrr1,
2745: msc_resource_requirements mrr2
2746: WHERE mrr1.plan_id = p_plan_id
2747: and mrr1.transaction_id = p_transaction_id
2748: and mrr1.sr_instance_id = p_instance_id
2749: and mrr2.plan_id = mrr1.plan_id

Line 2836: from msc_resource_requirements mrr,

2832: v_flag number :=2;
2833: Begin
2834: select nvl(mdr.batchable_flag, 2)
2835: into v_flag
2836: from msc_resource_requirements mrr,
2837: msc_department_resources mdr
2838: where mrr.plan_id = p_plan_id
2839: and mrr.transaction_id = p_transaction_id
2840: and mrr.sr_instance_id = p_instance_id

Line 2878: FROM msc_resource_requirements mrr

2874: mrr.start_date, mrr.end_date, mrr.supply_id
2875: into l_firm_flag, l_firm_start, l_firm_end,
2876: l_res_id, l_alt_num,
2877: l_start, l_end, l_supply_id
2878: FROM msc_resource_requirements mrr
2879: WHERE mrr.plan_id = p_plan_id
2880: and mrr.transaction_id = p_transaction_id
2881: and mrr.sr_instance_id = p_instance_id
2882: for update of mrr.firm_flag nowait;

Line 2922: update msc_resource_requirements

2918: --undo_change(p_plan_id, p_transaction_id, p_instance_id,
2919: -- l_firm_flag, l_firm_start, l_firm_end,
2920: -- l_res_id, l_alt_num);
2921: -- update data now
2922: update msc_resource_requirements
2923: set status =0,
2924: applied=2,
2925: firm_flag = l_firm_flag,
2926: firm_start_date =l_firm_start,

Line 2954: from msc_resource_requirements

2950: firm_end_date - ( end_date - start_date),
2951: FIRM_END_RES,
2952: firm_end_date - ( end_date - start_date),
2953: nvl(firm_start_date, start_date))
2954: from msc_resource_requirements
2955: where plan_id = p_plan_id
2956: and transaction_id = p_transaction_id
2957: and sr_instance_id = p_instance_id;
2958: v_temp date;

Line 2979: from msc_resource_requirements

2975: firm_start_date + ( end_date - start_date),
2976: FIRM_START_RES,
2977: firm_start_date + ( end_date - start_date),
2978: nvl(firm_end_date, end_date))
2979: from msc_resource_requirements
2980: where plan_id = p_plan_id
2981: and transaction_id = p_transaction_id
2982: and sr_instance_id = p_instance_id;
2983: v_temp date;

Line 3043: ' FROM msc_resource_requirements mrr, ' ||

3039: ' mrr.sr_instance_id) start_date, '||
3040: ' msc_get_gantt_data.get_end_date( ' ||
3041: 'mrr.plan_id, mrr.transaction_id, ' ||
3042: ' mrr.sr_instance_id) end_date '||
3043: ' FROM msc_resource_requirements mrr, ' ||
3044: ' msc_supplies ms, ' ||
3045: ' msc_trading_partners mtp ' ||
3046: ' WHERE ms.plan_id = :1 '||
3047: ' and mrr.plan_id = ms.plan_id ' ||

Line 3078: ' FROM msc_resource_requirements mrr, ' ||

3074: ' mrr.sr_instance_id) start_date, '||
3075: ' msc_get_gantt_data.get_end_date( ' ||
3076: 'mrr.plan_id, mrr.transaction_id, ' ||
3077: ' mrr.sr_instance_id) end_date '||
3078: ' FROM msc_resource_requirements mrr, ' ||
3079: ' msc_supplies ms, ' ||
3080: ' msc_trading_partners mtp, ' ||
3081: ' msc_exception_details med ' ||
3082: ' WHERE ms.plan_id = :1 '||

Line 3220: ' FROM msc_resource_requirements mrr, ' ||

3216:
3217: if p_from_block = 'RESOURCE' then
3218: sql_stat := ' SELECT distinct mrr.sr_instance_id, ' ||
3219: ' mrr.supply_id ' ||
3220: ' FROM msc_resource_requirements mrr, ' ||
3221: ' msc_department_resources mdr ' ||
3222: ' WHERE mrr.plan_id = '||p_plan_id ||
3223: ' AND mdr.plan_id = mrr.plan_id '||
3224: ' AND mdr.organization_id = mrr.organization_id ' ||

Line 3249: ' FROM msc_resource_requirements mrr, '||

3245: ' med.exception_type = 37)) '|| p_where ||
3246: ' union select mrr.sr_instance_id, '||
3247: ' mrr.supply_id transaction_id '||
3248: -- ' med.exception_detail_id '||
3249: ' FROM msc_resource_requirements mrr, '||
3250: ' msc_exception_details med '||
3251: ' where med.exception_type in (21,22,36,45,46) '||
3252: ' AND med.plan_id = mrr.plan_id ' ||
3253: ' AND med.organization_id = mrr.organization_id ' ||

Line 3313: ' FROM msc_resource_requirements mrr, ' ||

3309: sql_stat := ' SELECT distinct mrr.sr_instance_id, ' ||
3310: ' mrr.organization_id, '||
3311: ' mrr.department_id, '||
3312: ' mrr.resource_id '||
3313: ' FROM msc_resource_requirements mrr, ' ||
3314: ' msc_department_resources mdr, ' ||
3315: ' msc_exception_details med ' ||
3316: ' WHERE mrr.plan_id = :1 '||
3317: ' AND mdr.plan_id = mrr.plan_id '||

Line 3348: ' FROM msc_resource_requirements mrr, ' ||

3344: sql_stat := ' SELECT distinct mrr.sr_instance_id, ' ||
3345: ' mrr.organization_id, '||
3346: ' mrr.department_id, '||
3347: ' mrr.resource_id '||
3348: ' FROM msc_resource_requirements mrr, ' ||
3349: ' msc_department_resources mdr ' ||
3350: ' WHERE mrr.plan_id = :1 '||
3351: ' AND mdr.plan_id = mrr.plan_id '||
3352: ' AND mdr.organization_id = mrr.organization_id ' ||

Line 3836: -- get the children which have operation in msc_resource_requirements

3832: and mfq.number1 = p_supply_id
3833: and mfq.number2 is not null -- op_seq_num is not null
3834: );
3835:
3836: -- get the children which have operation in msc_resource_requirements
3837: Cursor job_data_cur(p_op_seq_num number) IS
3838: select distinct
3839: mfq.number3, -- ms.transaction_id,
3840: mfq.number4, -- ms.sr_instance_id,

Line 3914: from msc_resource_requirements mrr,

3910: decode(g_end_demand_id, null, 0,
3911: msc_get_gantt_data.isCriticalRes(p_plan_id,g_end_demand_id,
3912: ms.transaction_id, ms.sr_instance_id,
3913: mrr.operation_seq_num, mrr.routing_sequence_id))
3914: from msc_resource_requirements mrr,
3915: msc_supplies ms
3916: where mrr.plan_id = p_plan_id
3917: and mrr.supply_id = p_supply_id
3918: and mrr.parent_id =2

Line 4045: -- populate op seq num from msc_resource_requirements to msc_form_query

4041: peg_data.res_firm_flag(current_index); -- end supply tran id
4042: else
4043: p_end_supply_id := null;
4044: end if;
4045: -- populate op seq num from msc_resource_requirements to msc_form_query
4046:
4047: if p_op_seq_query_id is null then
4048: select msc_form_query_s.nextval
4049: into p_op_seq_query_id

Line 4071: from msc_resource_requirements mrr,

4067: -1,
4068: -1,
4069: p_supply_id,
4070: mrr.operation_seq_num
4071: from msc_resource_requirements mrr,
4072: msc_critical_paths mcp
4073: where mrr.plan_id = p_plan_id
4074: and mrr.supply_id = p_supply_id
4075: and mrr.sr_instance_id = p_instance_id

Line 4108: from msc_resource_requirements

4104: -1,
4105: -1,
4106: p_supply_id,
4107: operation_seq_num
4108: from msc_resource_requirements
4109: where plan_id = p_plan_id
4110: and supply_id = p_supply_id
4111: and sr_instance_id = p_instance_id
4112: and end_date is not null

Line 4422: -- if op exists in msc_demand but not in msc_resource_requirements,

4418: and msi.inventory_item_id = ms.inventory_item_id;
4419:
4420: end if;
4421:
4422: -- if op exists in msc_demand but not in msc_resource_requirements,
4423: -- show the op in the closest next op or prev op
4424:
4425: begin
4426: select distinct mfq.number2, mfq.number2

Line 5189: FROM msc_resource_requirements mrr,

5185: nvl(to_char(mrr.UEPSD,format_mask),'null') UEPSD,
5186: nvl(to_char(mrr.UEPCD,format_mask),'null') UEPCD,
5187: nvl(to_char(mrr.ULPSD,format_mask),'null') ULPSD,
5188: nvl(to_char(mrr.ULPCD,format_mask),'null') ULPCD
5189: FROM msc_resource_requirements mrr,
5190: msc_supplies ms,
5191: msc_department_resources mdr
5192: WHERE mrr.plan_id = p_plan_id
5193: AND mrr.transaction_id = p_transaction_id

Line 6268: from msc_resource_requirements mrr,

6264: msc_get_gantt_data.get_dmd_priority(
6265: mrr.plan_id, mrr.sr_instance_id, mrr.supply_id)),
6266: mrr.resource_hours/24/v_bkt_size
6267: bulk collect into v_id,v_qty
6268: from msc_resource_requirements mrr,
6269: msc_supplies ms
6270: where mrr.plan_id = p_plan_id
6271: and mrr.department_id = p_dept_id
6272: and mrr.sr_instance_id = p_instance_id