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 688: insert into msc_gantt_dtl_query ( query_id, row_type, row_index, parent_id,

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

Line 724: insert into msc_gantt_dtl_query (

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

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

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

Line 766: insert into msc_gantt_dtl_query (

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

Line 800: insert into msc_gantt_dtl_query (

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

Line 845: insert into msc_gantt_dtl_query (

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

Line 3833: from msc_gantt_dtl_query mgdq,

3829: l_op_seq, l_res_seq, l_res_desc, l_item_name, l_assy_item_desc, l_schedule_qty,
3830: l_from_setup_code, l_to_setup_code, l_std_op_code, l_changeover_time,
3831: l_changeover_penalty, l_min_capacity, l_max_capacity, l_capacity_used,
3832: l_overload_flag
3833: from msc_gantt_dtl_query mgdq,
3834: msc_gantt_query mgq
3835: where mgq.query_id = p_query_id
3836: and mgq.row_index = active_row.row_index
3837: and mgq.query_id = mgdq.query_id

Line 4129: from msc_gantt_dtl_query

4125: close c_supp_infinite_date;
4126:
4127: select trunc(start_date), nvl(resource_units,0)
4128: bulk collect into v_avail_start, v_avail_qty
4129: from msc_gantt_dtl_query
4130: where query_id = p_query_id
4131: and row_index = active_row.row_index
4132: and row_type = SUPP_AVAIL_ROW_TYPE
4133: and parent_id = SUMMARY_DATA;

Line 4139: from msc_gantt_dtl_query

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

Line 4216: from msc_gantt_dtl_query

4212: round(supp_avail_qty, ROUND_FACTOR),
4213: round(supp_overload_qty, ROUND_FACTOR),
4214: round(supp_consume_qty, ROUND_FACTOR)
4215: bulk collect into v_start_date, v_avail_qty, v_overload_qty, v_consume_qty
4216: from msc_gantt_dtl_query
4217: where query_id = p_query_id
4218: and row_index = active_row.row_index
4219: and row_type = SUPP_ALL_ROW_TYPE
4220: and parent_id = DETAIL_DATA

Line 4268: from msc_gantt_dtl_query

4264: schedule_flag,
4265: display_flag
4266: bulk collect into v_start, v_end, v_resource_hours, v_resource_units,
4267: v_schedule_flag, v_display_flag
4268: from msc_gantt_dtl_query
4269: where query_id = p_query_id
4270: and row_index = active_row.row_index
4271: and row_type = RES_REQ_ROW_TYPE
4272: and ( ( parent_id = SUMMARY_DATA and p_isBucketed = SYS_NO )

Line 4288: from msc_gantt_dtl_query

4284: schedule_flag,
4285: display_flag
4286: bulk collect into v_start, v_end, v_resource_hours, v_resource_units,
4287: v_schedule_flag, v_display_flag
4288: from msc_gantt_dtl_query
4289: where query_id = p_query_id
4290: and row_index = active_row.row_index
4291: and row_type = RES_REQ_ROW_TYPE
4292: and ( ( parent_id = SUMMARY_DATA and p_isBucketed = SYS_NO )

Line 4307: from msc_gantt_dtl_query

4303: round(resource_hours, ROUND_FACTOR) resource_hours,
4304: round(resource_units, ROUND_FACTOR) resource_units,
4305: schedule_flag
4306: bulk collect into v_start, v_end, v_resource_hours, v_resource_units, v_schedule_flag
4307: from msc_gantt_dtl_query
4308: where query_id = p_query_id
4309: and row_index = active_row.row_index
4310: and row_type = RES_AVAIL_ROW_TYPE
4311: and ( ( parent_id = SUMMARY_DATA and p_isBucketed = SYS_NO )

Line 4506: from msc_gantt_dtl_query

4502: end if;
4503:
4504: select start_date, end_date, resource_hours, nvl(display_flag, sys_no)
4505: bulk collect into v_setup_start, v_setup_end, v_setup_hours, v_setup_display_type
4506: from msc_gantt_dtl_query
4507: where query_id = p_query_id
4508: and row_index = active_row.row_index
4509: and row_type = RES_REQ_ROW_TYPE
4510: and parent_id = SUMMARY_DATA

Line 4519: from msc_gantt_dtl_query

4515:
4516:
4517: select start_date, end_date, resource_hours, nvl(display_flag, sys_no)
4518: bulk collect into v_req_start, v_req_end, v_req_hours, v_req_display_type
4519: from msc_gantt_dtl_query
4520: where query_id = p_query_id
4521: and row_index = active_row.row_index
4522: and row_type = RES_REQ_ROW_TYPE
4523: and parent_id = SUMMARY_DATA

Line 4531: from msc_gantt_dtl_query

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