DBA Data[Home] [Help]

APPS.WIP_BOMROUTINGUTIL_PVT dependencies on ENG_REVISED_ITEMS

Line 196: from eng_revised_items eng

192: and bos.effectivity_date <= p_routingRevDate
193: and nvl(bos.disable_date, p_routingRevDate+1) >= p_routingRevDate
194: and ( bos.implementation_date is not null
195: or exists (select 1
196: from eng_revised_items eng
197: where eng.change_notice = bos.change_notice
198: and eng.organization_id = p_orgID
199: and eng.routing_sequence_id = l_routingSeqID
200: and ((eng.status_type in (4, 7) and l_excludeECO = 1) or

Line 209: from eng_revised_items eng

205: and bos2.effectivity_date <= p_routingRevDate
206: and bos2.operation_seq_num = bos.operation_seq_num
207: and exists
208: (select 1
209: from eng_revised_items eng
210: where eng.change_notice = bos2.change_notice
211: and eng.organization_id = p_orgID
212: and eng.routing_sequence_id = l_routingSeqID
213: and ((eng.status_type in (4, 7) and l_excludeECO = 1) or

Line 363: from eng_revised_items eng

359: and nvl(bos2.operation_type, 1) = 1
360: and bos2.effectivity_date <= p_routingRevDate
361: and ( bos2.implementation_date is not null
362: or exists (select 1
363: from eng_revised_items eng
364: where eng.change_notice = bos2.change_notice
365: and eng.organization_id = p_orgID
366: and eng.routing_sequence_id = l_routingSeqID
367: and ((eng.status_type in (4, 7) and l_excludeECO = 1) or