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_GANTT_DTL_QUERY

Line 689: insert into msc_gantt_dtl_query ( query_id, row_type, row_index, parent_id,

685: p_schedule_flag number, p_detail_type number,
686: p_display_type number default null) is
687: begin
688:
689: insert into msc_gantt_dtl_query ( query_id, row_type, row_index, parent_id,
690: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
691: start_date, end_date, resource_units, resource_hours, schedule_flag, display_flag)
692: values ( p_query_id, p_row_type, p_row_index, p_detail_type,
693: sysdate, -1, sysdate, -1,-1,

Line 725: insert into msc_gantt_dtl_query (

721: l_res_units := p_resource_units(i);
722: l_res_hours := p_resource_hours(i);
723: end if;
724:
725: insert into msc_gantt_dtl_query (
726: query_id, row_type, row_index, parent_id,
727: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
728: start_date, end_date, resource_units, resource_hours, schedule_flag,
729: display_flag)

Line 744: insert into msc_gantt_dtl_query ( query_id, row_type, row_index, parent_id,

740: p_row_index number, p_start_date date, p_avail_qty number, p_overload_qty number,
741: p_consume_qty number, p_detail_type number) is
742: begin
743:
744: insert into msc_gantt_dtl_query ( query_id, row_type, row_index, parent_id,
745: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
746: start_date, supp_avail_qty, supp_overload_qty, supp_consume_qty)
747: values ( p_query_id, p_row_type, p_row_index, p_detail_type,
748: sysdate, -1, sysdate, -1,-1,

Line 767: insert into msc_gantt_dtl_query (

763: l_consumed_qty := p_number2(i);
764: else
765: l_consumed_qty := to_number(null);
766: end if;
767: insert into msc_gantt_dtl_query (
768: query_id, row_type, row_index, parent_id,
769: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
770: start_date, resource_units, resource_hours)
771: values (

Line 801: insert into msc_gantt_dtl_query (

797: begin
798:
799: forall i in p_sr_instance_id.first .. p_sr_instance_id.last
800: --loop
801: insert into msc_gantt_dtl_query (
802: query_id, row_type, row_index, parent_id,
803: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
804: sr_instance_id, organization_id, supply_id, transaction_id, status, applied,
805: res_firm_flag, sup_firm_flag, start_date, end_date, schedule_flag, late_flag,

Line 846: insert into msc_gantt_dtl_query (

842:
843: msc_gantt_utils.getBatchValues(g_plan_id, p_sr_instance_id(i), p_batch_number(i),
844: l_res_desc, l_min_capacity, l_max_capacity, l_capacity_used);
845:
846: insert into msc_gantt_dtl_query (
847: query_id, row_type, row_index, parent_id,
848: last_update_date, last_updated_by, creation_date, created_by, last_update_login,
849: sr_instance_id, organization_id, start_date, end_date, schedule_flag,
850: batch_number, supply_qty, bar_label,

Line 3838: from msc_gantt_dtl_query mgdq,

3834: l_op_seq, l_res_seq, l_res_desc, l_item_name, l_assy_item_desc, l_schedule_qty,
3835: l_from_setup_code, l_to_setup_code, l_std_op_code, l_changeover_time,
3836: l_changeover_penalty, l_min_capacity, l_max_capacity, l_capacity_used,
3837: l_overload_flag
3838: from msc_gantt_dtl_query mgdq,
3839: msc_gantt_query mgq
3840: where mgq.query_id = p_query_id
3841: and mgq.row_index = active_row.row_index
3842: and mgq.query_id = mgdq.query_id

Line 4134: from msc_gantt_dtl_query

4130: close c_supp_infinite_date;
4131:
4132: select trunc(start_date), nvl(resource_units,0)
4133: bulk collect into v_avail_start, v_avail_qty
4134: from msc_gantt_dtl_query
4135: where query_id = p_query_id
4136: and row_index = active_row.row_index
4137: and row_type = SUPP_AVAIL_ROW_TYPE
4138: and parent_id = SUMMARY_DATA;

Line 4144: from msc_gantt_dtl_query

4140: put_line(' row index and SUPP_AVAIL_ROW_TYPE count '||active_row.row_index||' '||v_avail_start.count);
4141:
4142: select trunc(start_date), nvl(resource_units,0), nvl(resource_hours,0)
4143: bulk collect into v_consume_start, v_overload_qty, v_consume_qty
4144: from msc_gantt_dtl_query
4145: where query_id = p_query_id
4146: and row_index = active_row.row_index
4147: and row_type = SUPP_ALL_ROW_TYPE
4148: and parent_id = SUMMARY_DATA

Line 4221: from msc_gantt_dtl_query

4217: round(supp_avail_qty, ROUND_FACTOR),
4218: round(supp_overload_qty, ROUND_FACTOR),
4219: round(supp_consume_qty, ROUND_FACTOR)
4220: bulk collect into v_start_date, v_avail_qty, v_overload_qty, v_consume_qty
4221: from msc_gantt_dtl_query
4222: where query_id = p_query_id
4223: and row_index = active_row.row_index
4224: and row_type = SUPP_ALL_ROW_TYPE
4225: and parent_id = DETAIL_DATA

Line 4273: from msc_gantt_dtl_query

4269: schedule_flag,
4270: display_flag
4271: bulk collect into v_start, v_end, v_resource_hours, v_resource_units,
4272: v_schedule_flag, v_display_flag
4273: from msc_gantt_dtl_query
4274: where query_id = p_query_id
4275: and row_index = active_row.row_index
4276: and row_type = RES_REQ_ROW_TYPE
4277: and ( ( parent_id = SUMMARY_DATA and p_isBucketed = SYS_NO )

Line 4293: from msc_gantt_dtl_query

4289: schedule_flag,
4290: display_flag
4291: bulk collect into v_start, v_end, v_resource_hours, v_resource_units,
4292: v_schedule_flag, v_display_flag
4293: from msc_gantt_dtl_query
4294: where query_id = p_query_id
4295: and row_index = active_row.row_index
4296: and row_type = RES_REQ_ROW_TYPE
4297: and ( ( parent_id = SUMMARY_DATA and p_isBucketed = SYS_NO )

Line 4312: from msc_gantt_dtl_query

4308: round(resource_hours, ROUND_FACTOR) resource_hours,
4309: round(resource_units, ROUND_FACTOR) resource_units,
4310: schedule_flag
4311: bulk collect into v_start, v_end, v_resource_hours, v_resource_units, v_schedule_flag
4312: from msc_gantt_dtl_query
4313: where query_id = p_query_id
4314: and row_index = active_row.row_index
4315: and row_type = RES_AVAIL_ROW_TYPE
4316: and ( ( parent_id = SUMMARY_DATA and p_isBucketed = SYS_NO )

Line 4511: from msc_gantt_dtl_query

4507: end if;
4508:
4509: select start_date, end_date, resource_hours, nvl(display_flag, sys_no)
4510: bulk collect into v_setup_start, v_setup_end, v_setup_hours, v_setup_display_type
4511: from msc_gantt_dtl_query
4512: where query_id = p_query_id
4513: and row_index = active_row.row_index
4514: and row_type = RES_REQ_ROW_TYPE
4515: and parent_id = SUMMARY_DATA

Line 4524: from msc_gantt_dtl_query

4520:
4521:
4522: select start_date, end_date, resource_hours, nvl(display_flag, sys_no)
4523: bulk collect into v_req_start, v_req_end, v_req_hours, v_req_display_type
4524: from msc_gantt_dtl_query
4525: where query_id = p_query_id
4526: and row_index = active_row.row_index
4527: and row_type = RES_REQ_ROW_TYPE
4528: and parent_id = SUMMARY_DATA

Line 4536: from msc_gantt_dtl_query

4532: msc_gantt_utils.put_line('prepareResHoursGantt: res req rows: '|| v_req_start.count);
4533:
4534: select start_date, end_date, resource_hours
4535: bulk collect into v_avail_start, v_avail_end, v_avail_hours
4536: from msc_gantt_dtl_query
4537: where query_id = p_query_id
4538: and row_index = active_row.row_index
4539: and parent_id = SUMMARY_DATA
4540: and row_type = RES_AVAIL_ROW_TYPE