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_GANTT_UTILS dependencies on MSC_RESOURCE_INSTANCE_REQS

Line 116: from msc_resource_instance_reqs mrir

112: and nvl(mrr.parent_id, 2) = 2;
113:
114: cursor res_inst_req_info (p_plan number, p_inst number, p_trx number) is
115: select mrir.batch_number
116: from msc_resource_instance_reqs mrir
117: where mrir.plan_id = p_plan
118: and mrir.sr_instancE_id = p_inst
119: and mrir.res_inst_transaction_id = p_trx
120: and nvl(mrir.parent_id, 2) = 2;

Line 240: msc_resource_instance_reqs mrir

236:
237: cursor child_res_inst_info (p_plan number, p_inst number, p_trx number) is
238: select mrir.res_inst_transaction_id
239: from msc_resource_requirements mrr,
240: msc_resource_instance_reqs mrir
241: where mrr.plan_id = p_plan
242: and mrr.sr_instance_id = p_inst
243: and mrr.transaction_id = p_trx
244: and mrr.plan_id = mrir.plan_id

Line 278: msc_resource_instance_reqs mrir

274:
275: cursor parent_res_info (p_plan number, p_inst number, p_trx number) is
276: select mrr.transaction_id
277: from msc_resource_requirements mrr,
278: msc_resource_instance_reqs mrir
279: where mrir.plan_id = p_plan
280: and mrir.sr_instance_id = p_inst
281: and mrir.res_inst_transaction_id = p_trx
282: and mrir.plan_id = mrr.plan_id

Line 2583: msc_resource_instance_reqs mrir,

2579: g_gantt_rh_toler_days_early,
2580: g_gantt_rh_toler_days_late) display_type
2581: from msc_gantt_query mgq,
2582: msc_resource_requirements mrr,
2583: msc_resource_instance_reqs mrir,
2584: msc_supplies ms
2585: where mgq.query_id = p_query_id
2586: and mgq.row_flag = SYS_YES
2587: and mgq.is_fetched = SYS_NO

Line 2654: msc_resource_instance_reqs mrir,

2650: g_gantt_rh_toler_days_late) display_type
2651: from msc_gantt_query mgq,
2652: msc_resource_requirements mrr,
2653: msc_resource_requirements mrr1,
2654: msc_resource_instance_reqs mrir,
2655: msc_supplies ms
2656: where mgq.query_id = p_query_id
2657: and mgq.row_flag = SYS_YES
2658: and mgq.is_fetched = SYS_NO

Line 2910: msc_resource_instance_reqs mrir,

2906: g_gantt_rh_toler_days_early,
2907: g_gantt_rh_toler_days_late)) display_type
2908: from msc_gantt_query mgq,
2909: msc_resource_requirements mrr,
2910: msc_resource_instance_reqs mrir,
2911: msc_resource_batches mrb,
2912: msc_supplies ms
2913: where mgq.query_id = p_query_id
2914: and mgq.row_flag = SYS_YES

Line 3006: msc_resource_instance_reqs mrir,

3002: from msc_gantt_query mgq,
3003: msc_resource_requirements mrr,
3004: msc_resource_requirements mrr1,
3005: msc_resource_batches mrb,
3006: msc_resource_instance_reqs mrir,
3007: msc_supplies ms
3008: where mgq.query_id = p_query_id
3009: and mgq.row_flag = SYS_YES
3010: and mgq.is_fetched = SYS_NO

Line 3395: from msc_resource_instance_reqs mrir,

3391: mrr.setup_id, 'TRANSITION_PENALTY')) changeover_penalty,
3392: msc_gantt_utils.isResOverload(mrr.plan_id, mrr.sr_instance_id,
3393: mrr.organization_id, ms.inventory_item_id,
3394: mrr.department_id, mrr.resource_id, mrr.supply_id) res_overload
3395: from msc_resource_instance_reqs mrir,
3396: msc_resource_requirements mrr,
3397: msc_department_resources mdr,
3398: msc_supplies ms,
3399: msc_items mi,

Line 3557: from msc_resource_instance_reqs mrir,

3553: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3554: to_char(sum(ms.new_order_quantity)),
3555: to_char(mrir.batch_number),
3556: to_char(sum(mrir.capacity_consumed_ratio))) bar_text
3557: from msc_resource_instance_reqs mrir,
3558: msc_resource_requirements mrr,
3559: msc_supplies ms,
3560: msc_gantt_query mgq
3561: where mgq.query_id = p_query_id

Line 5129: from msc_resource_instance_reqs

5125:
5126: cursor c_inst_req_for_same_req (p_plan number, p_res number, p_res_inst number, p_serial varchar2,
5127: p_supply number, p_op_seq_num number) is
5128: select count(*)
5129: from msc_resource_instance_reqs
5130: where plan_id = p_plan
5131: and resource_id = p_res
5132: and res_instance_id = p_res_inst
5133: and nvl(serial_number, mbp_null_value_char) = nvl(p_serial, mbp_null_value_char)

Line 5631: from msc_resource_instance_reqs mrir

5627: put_line(' lockReqInstNGetData in');
5628: -- lock the record first
5629: select mrir.supply_id, mrir.start_date, mrir.end_date
5630: into p_supply_id, p_start_date, p_end_date
5631: from msc_resource_instance_reqs mrir
5632: where mrir.plan_id = p_plan_id
5633: and mrir.sr_instance_id = p_inst_id
5634: and mrir.res_inst_transaction_id = p_trx_id
5635: for update of mrir.supply_id nowait;

Line 5768: from msc_resource_instance_reqs mrir

5764: -- lock MRIR
5765: begin
5766: select mrir.resource_id
5767: bulk collect into l_resource_id
5768: from msc_resource_instance_reqs mrir
5769: where mrir.plan_id = p_plan_id
5770: and mrir.sr_instance_id = p_inst_id
5771: and mrir.batch_number = p_batch_number
5772: for update of mrir.resource_id nowait;

Line 5777: msc_resource_instance_reqs mrir

5773:
5774: select count(*)
5775: into l_temp
5776: from msc_resource_requirements mrr,
5777: msc_resource_instance_reqs mrir
5778: where mrir.plan_id = p_plan_id
5779: and mrir.sr_instance_id = p_inst_id
5780: and mrir.batch_number = p_batch_number
5781: and mrir.plan_id = mrr.plan_id

Line 5810: update msc_resource_instance_reqs

5806: return;
5807: end;
5808:
5809: -- update MRIR
5810: update msc_resource_instance_reqs
5811: set status =0,
5812: applied=2,
5813: start_date = p_start_date,
5814: end_date = p_end_date

Line 5827: from msc_resource_instance_reqs mrir

5823: where plan_id = p_plan_id
5824: and sr_instance_id = p_inst_id
5825: and transaction_id in
5826: ( select distinct mrir.supply_id
5827: from msc_resource_instance_reqs mrir
5828: where mrir.plan_id = p_plan_id
5829: and mrir.sr_instance_id = p_inst_id
5830: and mrir.batch_number = p_batch_number );
5831:

Line 5983: from msc_resource_instance_reqs mrir

5979: l_hours number;
5980: begin
5981: select mrir.resource_id, resource_instance_hours
5982: into l_resource_id, l_hours
5983: from msc_resource_instance_reqs mrir
5984: where mrir.plan_id = p_plan_id
5985: and mrir.sr_instance_id = p_inst_id
5986: and mrir.res_inst_transaction_id = p_simu_res_trx
5987: for update of mrir.resource_id nowait;

Line 5989: update msc_resource_instance_reqs

5985: and mrir.sr_instance_id = p_inst_id
5986: and mrir.res_inst_transaction_id = p_simu_res_trx
5987: for update of mrir.resource_id nowait;
5988:
5989: update msc_resource_instance_reqs
5990: set status = 0,
5991: applied=2,
5992: resource_id = p_alt_res_id,
5993: res_instance_id = p_alt_res_instance_id,

Line 6029: from msc_resource_instance_reqs mrir

6025: begin
6026: put_line('DeleteReqInstFromAlt in '||p_plan_id||' '||p_inst_id||' '||p_res_inst_trx);
6027: select mrir.resource_id
6028: into l_resource_id
6029: from msc_resource_instance_reqs mrir
6030: where mrir.plan_id = p_plan_id
6031: and mrir.sr_instance_id = p_inst_id
6032: and mrir.res_inst_transaction_id = p_res_inst_trx
6033: for update of mrir.resource_id nowait;

Line 6035: delete msc_resource_instance_reqs mrir

6031: and mrir.sr_instance_id = p_inst_id
6032: and mrir.res_inst_transaction_id = p_res_inst_trx
6033: for update of mrir.resource_id nowait;
6034:
6035: delete msc_resource_instance_reqs mrir
6036: where mrir.plan_id = p_plan_id
6037: and mrir.sr_instance_id = p_inst_id
6038: and mrir.res_inst_transaction_id = p_res_inst_trx;
6039:

Line 6055: from msc_resource_instance_reqs

6051: l_trx_id number;
6052:
6053: cursor c_inst_row is
6054: select count(*)
6055: from msc_resource_instance_reqs
6056: where plan_id = p_plan_id
6057: and res_inst_transaction_id = l_trx_id;
6058:
6059: cursor c_equipment is

Line 6072: select msc_resource_instance_reqs_s.nextval

6068:
6069: l_temp number;
6070: begin
6071: put_line(' insertReqInstFromAlt plan inst trx '|| p_plan_id ||' '|| p_inst_id||' '|| p_simu_res_inst_trx);
6072: select msc_resource_instance_reqs_s.nextval
6073: into l_trx_id
6074: from dual;
6075:
6076: open c_equipment;

Line 6084: insert into msc_resource_instance_reqs(

6080: -- p_node_type = RES_NODE and p_to_node_type = RES_INST_NODE
6081: if (p_from_node = RES_INST_NODE) then -- {
6082: put_line(' insertReqInstFromAlt : trying to insert a row in mrir from mrir l_trx_id '||l_trx_id);
6083:
6084: insert into msc_resource_instance_reqs(
6085: RES_INST_TRANSACTION_ID, PLAN_ID, SR_INSTANCE_ID, ORGANIZATION_ID,
6086: SUPPLY_ID, DEPARTMENT_ID, RESOURCE_ID, RES_INSTANCE_ID, SERIAL_NUMBER, EQUIPMENT_ITEM_ID,
6087: PARENT_ID, PARENT_SEQ_NUM, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM, ORIG_RESOURCE_SEQ_NUM,
6088: SETUP_SEQUENCE_NUM, WIP_ENTITY_ID, START_DATE, END_DATE,

Line 6101: from msc_resource_instance_reqs mrir

6097: SETUP_SEQUENCE_NUM, WIP_ENTITY_ID, START_DATE, END_DATE,
6098: p_alt_res_hours, CAPACITY_CONSUMED, CAPACITY_CONSUMED_RATIO, BATCH_NUMBER,
6099: STATUS, APPLIED, UPDATED,
6100: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,LAST_UPDATE_LOGIN, REFRESH_NUMBER
6101: from msc_resource_instance_reqs mrir
6102: where mrir.plan_id = p_plan_id
6103: and mrir.sr_instance_id = p_inst_id
6104: and mrir.res_inst_transaction_id = p_simu_res_inst_trx;
6105:

Line 6120: insert into msc_resource_instance_reqs(

6116: if (p_from_node = RES_NODE) then -- {
6117:
6118: put_line(' insertReqInstFromAlt : trying to insert a row in mrir from mrr l_trx_id '||l_trx_id);
6119:
6120: insert into msc_resource_instance_reqs(
6121: RES_INST_TRANSACTION_ID, PLAN_ID, SR_INSTANCE_ID, ORGANIZATION_ID,
6122: SUPPLY_ID, DEPARTMENT_ID, RESOURCE_ID, RES_INSTANCE_ID, SERIAL_NUMBER, EQUIPMENT_ITEM_ID,
6123: PARENT_ID, PARENT_SEQ_NUM, OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM, ORIG_RESOURCE_SEQ_NUM,
6124: --SETUP_SEQUENCE_NUM,

Line 6163: select msc_resource_instance_reqs_s.nextval

6159: p_alt_res_basis_type number,
6160: p_alt_orig_res_seq_num number) return number is
6161: l_trx_id number;
6162: begin
6163: select msc_resource_instance_reqs_s.nextval
6164: into l_trx_id
6165: from dual;
6166:
6167: insert into msc_resource_requirements(

Line 6301: update msc_resource_instance_reqs

6297:
6298: procedure updateReqInst(p_plan_id number, p_inst_id number, p_trx_id number,
6299: p_start_date date, p_end_date date) is
6300: begin
6301: update msc_resource_instance_reqs
6302: set status =0,
6303: applied=2,
6304: start_date = p_start_date,
6305: end_date = p_end_date,

Line 6331: update msc_resource_instance_reqs

6327: open c_res_req_dates;
6328: fetch c_res_req_dates into l_start_date, l_end_date;
6329: close c_res_req_dates;
6330:
6331: update msc_resource_instance_reqs
6332: set status =0,
6333: applied=2,
6334: start_date = l_start_date,
6335: end_date = l_end_date

Line 6496: msc_resource_instance_reqs mrir,

6492: decode(ms.order_type, 27, 1, ms.firm_planned_type) firm_planned_type,
6493: sysdate theDate,
6494: getMTQTime(p_transaction_id, p_plan_id, p_instance_id) mtq_time
6495: from msc_resource_requirements mrr,
6496: msc_resource_instance_reqs mrir,
6497: msc_supplies ms
6498: where mrir.plan_id = p_plan_id
6499: and mrir.sr_instance_id = p_instance_id
6500: and mrir.res_inst_transaction_id = p_transaction_id

Line 6541: msc_resource_instance_reqs mrir1,

6537: (nvl(mrir2.end_date, mrir2.start_date+mrir2.resource_instance_hours/24) - mrir2.start_date),
6538: nvl(nvl(mrr2.firm_end_date, mrir2.end_date), mrir2.start_date+mrir2.resource_instance_hours/24)) end_date,
6539: msc_gantt_utils.getMTQTime(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
6540: from msc_resource_requirements mrr1,
6541: msc_resource_instance_reqs mrir1,
6542: msc_resource_requirements mrr2,
6543: msc_resource_instance_reqs mrir2,
6544: msc_routings mr
6545: where mrir1.plan_id = p_plan_id

Line 6543: msc_resource_instance_reqs mrir2,

6539: msc_gantt_utils.getMTQTime(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
6540: from msc_resource_requirements mrr1,
6541: msc_resource_instance_reqs mrir1,
6542: msc_resource_requirements mrr2,
6543: msc_resource_instance_reqs mrir2,
6544: msc_routings mr
6545: where mrir1.plan_id = p_plan_id
6546: and mrir1.res_inst_transaction_id = p_transaction_id
6547: and mrir1.sr_instance_id = p_instance_id

Line 6619: msc_resource_instance_reqs mrir1,

6615: FIRM_START_RES, mrr2.firm_start_date +
6616: (nvl(mrir2.end_date, mrir2.start_date+mrir2.resource_instance_hours/24) - mrir2.start_date),
6617: nvl(nvl(mrr2.firm_end_date, mrir2.end_date), mrir2.start_date+mrir2.resource_instance_hours/24)) end_date
6618: from msc_resource_requirements mrr1,
6619: msc_resource_instance_reqs mrir1,
6620: msc_resource_requirements mrr2,
6621: msc_resource_instance_reqs mrir2,
6622: msc_routings mr
6623: where mrir1.plan_id = p_plan_id

Line 6621: msc_resource_instance_reqs mrir2,

6617: nvl(nvl(mrr2.firm_end_date, mrir2.end_date), mrir2.start_date+mrir2.resource_instance_hours/24)) end_date
6618: from msc_resource_requirements mrr1,
6619: msc_resource_instance_reqs mrir1,
6620: msc_resource_requirements mrr2,
6621: msc_resource_instance_reqs mrir2,
6622: msc_routings mr
6623: where mrir1.plan_id = p_plan_id
6624: and mrir1.res_inst_transaction_id = p_transaction_id
6625: and mrir1.sr_instance_id = p_instance_id

Line 7380: from msc_resource_instance_reqs mrir

7376:
7377: --5513960 bugfix
7378: cursor c_res_inst_info (p_plan number, p_inst number, p_trx number)is
7379: select mrir.res_instance_id, mrir.serial_number, mrir.equipment_item_id
7380: from msc_resource_instance_reqs mrir
7381: where mrir.plan_id = p_plan
7382: and mrir.sr_instance_id = p_inst
7383: and mrir.res_inst_transaction_id = p_trx;
7384: