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 239: msc_resource_instance_reqs mrir

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

Line 277: msc_resource_instance_reqs mrir

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

Line 2582: msc_resource_instance_reqs mrir,

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

Line 2653: msc_resource_instance_reqs mrir,

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

Line 2905: msc_resource_instance_reqs mrir,

2901: g_gantt_rh_toler_days_early,
2902: g_gantt_rh_toler_days_late)) display_type
2903: from msc_gantt_query mgq,
2904: msc_resource_requirements mrr,
2905: msc_resource_instance_reqs mrir,
2906: msc_resource_batches mrb,
2907: msc_supplies ms
2908: where mgq.query_id = p_query_id
2909: and mgq.row_flag = SYS_YES

Line 3001: msc_resource_instance_reqs mrir,

2997: from msc_gantt_query mgq,
2998: msc_resource_requirements mrr,
2999: msc_resource_requirements mrr1,
3000: msc_resource_batches mrb,
3001: msc_resource_instance_reqs mrir,
3002: msc_supplies ms
3003: where mgq.query_id = p_query_id
3004: and mgq.row_flag = SYS_YES
3005: and mgq.is_fetched = SYS_NO

Line 3390: from msc_resource_instance_reqs mrir,

3386: mrr.setup_id, 'TRANSITION_PENALTY')) changeover_penalty,
3387: msc_gantt_utils.isResOverload(mrr.plan_id, mrr.sr_instance_id,
3388: mrr.organization_id, ms.inventory_item_id,
3389: mrr.department_id, mrr.resource_id, mrr.supply_id) res_overload
3390: from msc_resource_instance_reqs mrir,
3391: msc_resource_requirements mrr,
3392: msc_department_resources mdr,
3393: msc_supplies ms,
3394: msc_items mi,

Line 3552: from msc_resource_instance_reqs mrir,

3548: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3549: to_char(sum(ms.new_order_quantity)),
3550: to_char(mrir.batch_number),
3551: to_char(sum(mrir.capacity_consumed_ratio))) bar_text
3552: from msc_resource_instance_reqs mrir,
3553: msc_resource_requirements mrr,
3554: msc_supplies ms,
3555: msc_gantt_query mgq
3556: where mgq.query_id = p_query_id

Line 5124: from msc_resource_instance_reqs

5120:
5121: cursor c_inst_req_for_same_req (p_plan number, p_res number, p_res_inst number, p_serial varchar2,
5122: p_supply number, p_op_seq_num number) is
5123: select count(*)
5124: from msc_resource_instance_reqs
5125: where plan_id = p_plan
5126: and resource_id = p_res
5127: and res_instance_id = p_res_inst
5128: and nvl(serial_number, mbp_null_value_char) = nvl(p_serial, mbp_null_value_char)

Line 5626: from msc_resource_instance_reqs mrir

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

Line 5763: from msc_resource_instance_reqs mrir

5759: -- lock MRIR
5760: begin
5761: select mrir.resource_id
5762: bulk collect into l_resource_id
5763: from msc_resource_instance_reqs mrir
5764: where mrir.plan_id = p_plan_id
5765: and mrir.sr_instance_id = p_inst_id
5766: and mrir.batch_number = p_batch_number
5767: for update of mrir.resource_id nowait;

Line 5772: msc_resource_instance_reqs mrir

5768:
5769: select count(*)
5770: into l_temp
5771: from msc_resource_requirements mrr,
5772: msc_resource_instance_reqs mrir
5773: where mrir.plan_id = p_plan_id
5774: and mrir.sr_instance_id = p_inst_id
5775: and mrir.batch_number = p_batch_number
5776: and mrir.plan_id = mrr.plan_id

Line 5805: update msc_resource_instance_reqs

5801: return;
5802: end;
5803:
5804: -- update MRIR
5805: update msc_resource_instance_reqs
5806: set status =0,
5807: applied=2,
5808: start_date = p_start_date,
5809: end_date = p_end_date

Line 5822: from msc_resource_instance_reqs mrir

5818: where plan_id = p_plan_id
5819: and sr_instance_id = p_inst_id
5820: and transaction_id in
5821: ( select distinct mrir.supply_id
5822: from msc_resource_instance_reqs mrir
5823: where mrir.plan_id = p_plan_id
5824: and mrir.sr_instance_id = p_inst_id
5825: and mrir.batch_number = p_batch_number );
5826:

Line 5978: from msc_resource_instance_reqs mrir

5974: l_hours number;
5975: begin
5976: select mrir.resource_id, resource_instance_hours
5977: into l_resource_id, l_hours
5978: from msc_resource_instance_reqs mrir
5979: where mrir.plan_id = p_plan_id
5980: and mrir.sr_instance_id = p_inst_id
5981: and mrir.res_inst_transaction_id = p_simu_res_trx
5982: for update of mrir.resource_id nowait;

Line 5984: update msc_resource_instance_reqs

5980: and mrir.sr_instance_id = p_inst_id
5981: and mrir.res_inst_transaction_id = p_simu_res_trx
5982: for update of mrir.resource_id nowait;
5983:
5984: update msc_resource_instance_reqs
5985: set status = 0,
5986: applied=2,
5987: resource_id = p_alt_res_id,
5988: res_instance_id = p_alt_res_instance_id,

Line 6024: from msc_resource_instance_reqs mrir

6020: begin
6021: put_line('DeleteReqInstFromAlt in '||p_plan_id||' '||p_inst_id||' '||p_res_inst_trx);
6022: select mrir.resource_id
6023: into l_resource_id
6024: from msc_resource_instance_reqs mrir
6025: where mrir.plan_id = p_plan_id
6026: and mrir.sr_instance_id = p_inst_id
6027: and mrir.res_inst_transaction_id = p_res_inst_trx
6028: for update of mrir.resource_id nowait;

Line 6030: delete msc_resource_instance_reqs mrir

6026: and mrir.sr_instance_id = p_inst_id
6027: and mrir.res_inst_transaction_id = p_res_inst_trx
6028: for update of mrir.resource_id nowait;
6029:
6030: delete msc_resource_instance_reqs mrir
6031: where mrir.plan_id = p_plan_id
6032: and mrir.sr_instance_id = p_inst_id
6033: and mrir.res_inst_transaction_id = p_res_inst_trx;
6034:

Line 6050: from msc_resource_instance_reqs

6046: l_trx_id number;
6047:
6048: cursor c_inst_row is
6049: select count(*)
6050: from msc_resource_instance_reqs
6051: where plan_id = p_plan_id
6052: and res_inst_transaction_id = l_trx_id;
6053:
6054: cursor c_equipment is

Line 6067: select msc_resource_instance_reqs_s.nextval

6063:
6064: l_temp number;
6065: begin
6066: put_line(' insertReqInstFromAlt plan inst trx '|| p_plan_id ||' '|| p_inst_id||' '|| p_simu_res_inst_trx);
6067: select msc_resource_instance_reqs_s.nextval
6068: into l_trx_id
6069: from dual;
6070:
6071: open c_equipment;

Line 6079: insert into msc_resource_instance_reqs(

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

Line 6096: from msc_resource_instance_reqs mrir

6092: SETUP_SEQUENCE_NUM, WIP_ENTITY_ID, START_DATE, END_DATE,
6093: p_alt_res_hours, CAPACITY_CONSUMED, CAPACITY_CONSUMED_RATIO, BATCH_NUMBER,
6094: STATUS, APPLIED, UPDATED,
6095: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,LAST_UPDATE_LOGIN, REFRESH_NUMBER
6096: from msc_resource_instance_reqs mrir
6097: where mrir.plan_id = p_plan_id
6098: and mrir.sr_instance_id = p_inst_id
6099: and mrir.res_inst_transaction_id = p_simu_res_inst_trx;
6100:

Line 6115: insert into msc_resource_instance_reqs(

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

Line 6158: select msc_resource_instance_reqs_s.nextval

6154: p_alt_res_basis_type number,
6155: p_alt_orig_res_seq_num number) return number is
6156: l_trx_id number;
6157: begin
6158: select msc_resource_instance_reqs_s.nextval
6159: into l_trx_id
6160: from dual;
6161:
6162: insert into msc_resource_requirements(

Line 6296: update msc_resource_instance_reqs

6292:
6293: procedure updateReqInst(p_plan_id number, p_inst_id number, p_trx_id number,
6294: p_start_date date, p_end_date date) is
6295: begin
6296: update msc_resource_instance_reqs
6297: set status =0,
6298: applied=2,
6299: start_date = p_start_date,
6300: end_date = p_end_date,

Line 6326: update msc_resource_instance_reqs

6322: open c_res_req_dates;
6323: fetch c_res_req_dates into l_start_date, l_end_date;
6324: close c_res_req_dates;
6325:
6326: update msc_resource_instance_reqs
6327: set status =0,
6328: applied=2,
6329: start_date = l_start_date,
6330: end_date = l_end_date

Line 6491: msc_resource_instance_reqs mrir,

6487: decode(ms.order_type, 27, 1, ms.firm_planned_type) firm_planned_type,
6488: sysdate theDate,
6489: getMTQTime(p_transaction_id, p_plan_id, p_instance_id) mtq_time
6490: from msc_resource_requirements mrr,
6491: msc_resource_instance_reqs mrir,
6492: msc_supplies ms
6493: where mrir.plan_id = p_plan_id
6494: and mrir.sr_instance_id = p_instance_id
6495: and mrir.res_inst_transaction_id = p_transaction_id

Line 6536: msc_resource_instance_reqs mrir1,

6532: (nvl(mrir2.end_date, mrir2.start_date+mrir2.resource_instance_hours/24) - mrir2.start_date),
6533: nvl(nvl(mrr2.firm_end_date, mrir2.end_date), mrir2.start_date+mrir2.resource_instance_hours/24)) end_date,
6534: msc_gantt_utils.getMTQTime(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
6535: from msc_resource_requirements mrr1,
6536: msc_resource_instance_reqs mrir1,
6537: msc_resource_requirements mrr2,
6538: msc_resource_instance_reqs mrir2,
6539: msc_routings mr
6540: where mrir1.plan_id = p_plan_id

Line 6538: msc_resource_instance_reqs mrir2,

6534: msc_gantt_utils.getMTQTime(mrr2.transaction_id, p_plan_id, p_instance_id) mtq_time
6535: from msc_resource_requirements mrr1,
6536: msc_resource_instance_reqs mrir1,
6537: msc_resource_requirements mrr2,
6538: msc_resource_instance_reqs mrir2,
6539: msc_routings mr
6540: where mrir1.plan_id = p_plan_id
6541: and mrir1.res_inst_transaction_id = p_transaction_id
6542: and mrir1.sr_instance_id = p_instance_id

Line 6614: msc_resource_instance_reqs mrir1,

6610: FIRM_START_RES, mrr2.firm_start_date +
6611: (nvl(mrir2.end_date, mrir2.start_date+mrir2.resource_instance_hours/24) - mrir2.start_date),
6612: nvl(nvl(mrr2.firm_end_date, mrir2.end_date), mrir2.start_date+mrir2.resource_instance_hours/24)) end_date
6613: from msc_resource_requirements mrr1,
6614: msc_resource_instance_reqs mrir1,
6615: msc_resource_requirements mrr2,
6616: msc_resource_instance_reqs mrir2,
6617: msc_routings mr
6618: where mrir1.plan_id = p_plan_id

Line 6616: msc_resource_instance_reqs mrir2,

6612: nvl(nvl(mrr2.firm_end_date, mrir2.end_date), mrir2.start_date+mrir2.resource_instance_hours/24)) end_date
6613: from msc_resource_requirements mrr1,
6614: msc_resource_instance_reqs mrir1,
6615: msc_resource_requirements mrr2,
6616: msc_resource_instance_reqs mrir2,
6617: msc_routings mr
6618: where mrir1.plan_id = p_plan_id
6619: and mrir1.res_inst_transaction_id = p_transaction_id
6620: and mrir1.sr_instance_id = p_instance_id

Line 7375: from msc_resource_instance_reqs mrir

7371:
7372: --5513960 bugfix
7373: cursor c_res_inst_info (p_plan number, p_inst number, p_trx number)is
7374: select mrir.res_instance_id, mrir.serial_number, mrir.equipment_item_id
7375: from msc_resource_instance_reqs mrir
7376: where mrir.plan_id = p_plan
7377: and mrir.sr_instance_id = p_inst
7378: and mrir.res_inst_transaction_id = p_trx;
7379: