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_JOB_OP_RESOURCES

Line 5175: msc_job_op_resources mjor,

5171: ms.new_order_quantity qty,
5172: mrr.assigned_units,
5173: mrr.firm_flag
5174: from msc_resource_requirements mrr,
5175: msc_job_op_resources mjor,
5176: msc_supplies ms
5177: where mrr.plan_id = p_plan
5178: and mrr.transaction_id = p_trx
5179: and mrr.sr_instance_id = p_inst

Line 5247: msc_job_op_resources mjor

5243: select distinct mrr.transaction_id,
5244: mjor.principal_flag,
5245: mrr.resource_id
5246: from msc_resource_requirements mrr,
5247: msc_job_op_resources mjor
5248: where mrr.plan_id = p_plan
5249: and mrr.sr_instance_id = p_inst
5250: and mrr.routing_sequence_id is null
5251: and mrr.operation_seq_num = p_op_seq_num

Line 5289: from msc_job_op_resources mjor

5285: mjor.alternate_num,
5286: mjor.principal_flag,
5287: mjor.basis_type,
5288: mjor.orig_resource_seq_num
5289: from msc_job_op_resources mjor
5290: where mjor.plan_id = p_plan
5291: and mjor.sr_instance_id = p_inst
5292: and mjor.transaction_id = p_supply_id
5293: and mjor.operation_seq_num = p_op_seq_num

Line 7170: from msc_job_op_resources mjor,

7166: mjor.resource_id,
7167: mbp_null_value res_instance_id,
7168: mbp_null_value_char serial_number,
7169: mjor.alternate_num
7170: from msc_job_op_resources mjor,
7171: msc_resource_requirements mrr
7172: where mrr.plan_id = p_plan
7173: and mrr.sr_instance_id = p_inst
7174: and mrr.transaction_id = p_trx

Line 7220: from msc_job_op_resources mjor,

7216: mdri.resource_id,
7217: mdri.res_instance_id,
7218: mdri.serial_number,
7219: mjor.alternate_num
7220: from msc_job_op_resources mjor,
7221: msc_resource_requirements mrr,
7222: msc_dept_res_instances mdri
7223: where mrr.plan_id = p_plan
7224: and mrr.sr_instance_id = p_inst

Line 7269: from msc_job_op_resources mjor,

7265: mjor.resource_id,
7266: mbp_null_value res_instance_id,
7267: mbp_null_value_char serial_number,
7268: mjor.alternate_num
7269: from msc_job_op_resources mjor,
7270: msc_resource_requirements mrr
7271: where mrr.plan_id = p_plan
7272: and mrr.sr_instance_id = p_inst
7273: and mrr.transaction_id = p_trx

Line 7337: from msc_job_op_resources mjor,

7333: mdri.resource_id,
7334: mdri.res_instance_id,
7335: mdri.serial_number,
7336: mjor.alternate_num
7337: from msc_job_op_resources mjor,
7338: msc_resource_requirements mrr,
7339: msc_dept_res_instances mdri
7340: where mrr.plan_id = p_plan
7341: and mrr.sr_instance_id = p_inst