DBA Data[Home] [Help]

APPS.MSC_GANTT_UTILS dependencies on MSC_PROCESS_EFFECTIVITY

Line 5299: msc_process_effectivity mpe,

5295: cursor assembly_qty (p_plan number, p_supply number) is
5296: select nvl(assembly_quantity,1) assembly_quantity
5297: from msc_boms mb,
5298: msc_supplies ms,
5299: msc_process_effectivity mpe,
5300: msc_resource_requirements mrr
5301: where ms.plan_id = p_plan
5302: and ms.transaction_id = p_supply
5303: and ms.plan_id = mrr.plan_id

Line 8391: msc_process_effectivity pe

8387: from msc_supplies ms,
8388: msc_resource_requirements mrr,
8389: msc_department_resources mdr,
8390: msc_system_items msi,
8391: msc_process_effectivity pe
8392: where pe.plan_id(+) = ms.plan_id
8393: and pe.sr_instance_id(+) = ms.sr_instance_id
8394: and pe.process_sequence_id(+) = ms.process_seq_id
8395: and mrr.plan_id = p_plan_id