DBA Data[Home] [Help]

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_PROCESS_EFFECTIVITY

Line 66: from msc_routings b, msc_process_effectivity p

62: alt_rtg varchar2(40) ; --5338566 bugfix, length changed to 40
63: begin
64: select alternate_routing_designator
65: into alt_rtg
66: from msc_routings b, msc_process_effectivity p
67: where p.plan_id = b.plan_id
68: and p.sr_instance_id= b.sr_instance_id
69: and p.routing_sequence_id = b.routing_sequence_id
70: and p.process_sequence_id = p_proc_seq_id

Line 88: from msc_boms b, msc_process_effectivity p

84: begin
85:
86: select alternate_bom_designator
87: into alt_bom
88: from msc_boms b, msc_process_effectivity p
89: where p.plan_id = b.plan_id
90: and p.sr_instance_id= p.sr_instance_id
91: and p.bill_sequence_id = b.bill_sequence_id
92: and p.process_sequence_id = p_proc_seq_id