DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on MSC_PROCESS_EFFECTIVITY

Line 5304: msc_process_effectivity mpe,

5300: cursor assembly_qty (p_plan number, p_supply number) is
5301: select nvl(assembly_quantity,1) assembly_quantity
5302: from msc_boms mb,
5303: msc_supplies ms,
5304: msc_process_effectivity mpe,
5305: msc_resource_requirements mrr
5306: where ms.plan_id = p_plan
5307: and ms.transaction_id = p_supply
5308: and ms.plan_id = mrr.plan_id

Line 8396: msc_process_effectivity pe

8392: from msc_supplies ms,
8393: msc_resource_requirements mrr,
8394: msc_department_resources mdr,
8395: msc_system_items msi,
8396: msc_process_effectivity pe
8397: where pe.plan_id(+) = ms.plan_id
8398: and pe.sr_instance_id(+) = ms.sr_instance_id
8399: and pe.process_sequence_id(+) = ms.process_seq_id
8400: and mrr.plan_id = p_plan_id