DBA Data[Home] [Help]

APPS.MSC_GET_GANTT_DATA dependencies on MSC_SYSTEM_ITEMS

Line 1861: msc_system_items msi,

1857: nvl(to_char(mrr.ULPCD,format_mask),'null') ULPCD
1858: FROM msc_supplies ms,
1859: msc_resource_requirements mrr,
1860: msc_department_resources mdr,
1861: msc_system_items msi,
1862: msc_process_effectivity pe
1863: WHERE pe.plan_id(+) = ms.plan_id
1864: AND pe.sr_instance_id(+) = ms.sr_instance_id
1865: AND pe.process_sequence_id(+) = ms.process_seq_id

Line 2710: from msc_system_items msi,

2706: mrr.firm_end_date - (mrr.end_date - mrr.start_date),
2707: nvl(mrr.firm_start_date, mrr.start_date)),
2708: msi.PLANNING_TIME_FENCE_DATE
2709: into l_prev_start_date, l_timefence_date
2710: from msc_system_items msi,
2711: msc_resource_requirements mrr,
2712: msc_supplies ms
2713: where mrr.plan_id = p_plan_id
2714: and mrr.transaction_id = p_transaction_id

Line 3808: msc_system_items msi,

3804: nvl(ms.supplier_id,-1)
3805: from msc_full_pegging mfp1,
3806: msc_full_pegging mfp2,
3807: msc_supplies ms,
3808: msc_system_items msi,
3809: msc_trading_partners mtp,
3810: msc_form_query mfq
3811: where mfp1.plan_id = p_plan_id
3812: and mfp1.transaction_id = p_supply_id

Line 4280: msc_system_items msi,

4276: from msc_full_pegging mfp1,
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

Line 4398: msc_system_items msi,

4394: ms.inventory_item_id,
4395: nvl(ms.supplier_id,-1)
4396: from msc_full_pegging mfp1,
4397: msc_full_pegging mfp2,
4398: msc_system_items msi,
4399: msc_supplies ms,
4400: msc_demands md,
4401: msc_form_query mfq
4402: where mfp1.plan_id = p_plan_id

Line 4821: msc_system_items msi,

4817: from msc_full_pegging mfp1,
4818: msc_full_pegging mfp2,
4819: msc_form_query mfq,
4820: msc_supplies ms,
4821: msc_system_items msi,
4822: msc_trading_partners mtp
4823: where mfp1.pegging_id = mfp2.end_pegging_id
4824: and mfp1.plan_id = mfp2.plan_id
4825: and mfp1.sr_instance_id = mfp2.sr_instance_id

Line 4869: msc_system_items msi,

4865: ms.source_organization_id)
4866: from msc_full_pegging mfp2,
4867: msc_form_query mfq,
4868: msc_supplies ms,
4869: msc_system_items msi,
4870: msc_trading_partners mtp
4871: where mfp2.plan_id = p_plan_id
4872: and mfp2.transaction_id = mfq.number1
4873: and mfp2.sr_instance_id = mfq.number2

Line 5143: msc_system_items msi

5139: nvl(to_char(ms.UEPCD,format_mask),'null') UEPCD,
5140: nvl(to_char(ms.ULPSD,format_mask),'null') ULPSD,
5141: nvl(to_char(ms.ULPCD,format_mask),'null') ULPCD
5142: FROM msc_supplies ms,
5143: msc_system_items msi
5144: WHERE ms.plan_id = p_plan_id
5145: AND ms.transaction_id = p_transaction_id
5146: and ms.sr_instance_id = p_instance_id
5147: and msi.plan_id = ms.plan_id

Line 5784: msc_system_items msi,

5780: ms.inventory_item_id,
5781: nvl(ms.supplier_id,-1)
5782: from msc_full_pegging mfp,
5783: msc_supplies ms,
5784: msc_system_items msi,
5785: msc_trading_partners mtp
5786: where mfp.demand_id = p_demand_id
5787: and mfp.plan_id = p_plan_id
5788: and msi.plan_id = ms.plan_id