DBA Data[Home] [Help]

APPS.MSC_GET_GANTT_DATA dependencies on MSC_CRITICAL_PATHS

Line 4072: msc_critical_paths mcp

4068: -1,
4069: p_supply_id,
4070: mrr.operation_seq_num
4071: from msc_resource_requirements mrr,
4072: msc_critical_paths mcp
4073: where mrr.plan_id = p_plan_id
4074: and mrr.supply_id = p_supply_id
4075: and mrr.sr_instance_id = p_instance_id
4076: and mrr.end_date is not null

Line 4281: msc_critical_paths mcp,

4277: msc_full_pegging mfp2,
4278: msc_supplies ms,
4279: msc_demands md,
4280: msc_system_items msi,
4281: msc_critical_paths mcp,
4282: msc_form_query mfq
4283: where mfp1.plan_id = p_plan_id
4284: and mfp1.transaction_id = p_supply_id
4285: and mfp1.end_pegging_id = mfq.number1

Line 6073: from msc_critical_paths

6069: isCritical number :=-1;
6070:
6071: CURSOR critical_cur is
6072: select nvl(path_number,1)
6073: from msc_critical_paths
6074: where plan_id = p_plan_id
6075: and supply_id = p_transaction_id
6076: and sr_instance_id = p_inst_id
6077: and demand_id = p_end_demand_id

Line 6099: from msc_critical_paths

6095: isCritical number :=-1;
6096:
6097: CURSOR critical_cur is
6098: select nvl(path_number,1)
6099: from msc_critical_paths
6100: where plan_id = p_plan_id
6101: and supply_id = p_transaction_id
6102: and sr_instance_id = p_inst_id
6103: and demand_id = p_end_demand_id