APPS.FLM_COPY_ROUTING dependencies on BOM_OPERATION_SEQUENCES_V

Line 233: select 1 from bom_operation_sequences_v bosv

229: and (p_assembly_name_to is NULL or p_assembly_name_to >= msi_kfv.concatenated_segments)
230: and (p_tpct_from is NULL or bor.total_product_cycle_time >= p_tpct_from)
231: and (p_tpct_to is NULL or bor.total_product_cycle_time <= p_tpct_to)
232: and (p_lineop_code is NULL or exists (
233: select 1 from bom_operation_sequences_v bosv
234: where bosv.routing_sequence_id = bor.common_routing_sequence_id
235: and p_lineop_code = bosv.standard_operation_code
236: and bosv.operation_type = 3)
237: )

Line 239: select 1 from bom_operation_sequences_v bosv

235: and p_lineop_code = bosv.standard_operation_code
236: and bosv.operation_type = 3)
237: )
238: and (p_process_code is NULL or exists (
239: select 1 from bom_operation_sequences_v bosv
240: where bosv.routing_sequence_id = bor.common_routing_sequence_id
241: and p_process_code = bosv.standard_operation_code
242: and bosv.operation_type = 2)
243: )

Line 440: bom_operation_sequences_v bosv

436: ,NULL Return_Status
437: ,NULL Delete_Group_Name
438: ,NULL DG_Description
439: From
440: bom_operation_sequences_v bosv
441: Where
442: bosv.routing_sequence_id = p_routing_sequence_id
443: and ((bosv.effectivity_date <= l_today and nvl(bosv.disable_date,l_today+1) > l_today)
444: or (bosv.effectivity_date > l_today and nvl(bosv.disable_date, bosv.effectivity_date+1) > bosv.effectivity_date))

Line 512: bom_operation_sequences_v bosv

508: standard_operation_id
509: ,standard_operation_code
510: ,operation_type
511: From
512: bom_operation_sequences_v bosv
513: Where
514: routing_sequence_id = p_routing_sequence_id
515: and ((effectivity_date <= l_today and nvl(disable_date,l_today+1) > l_today)
516: or (effectivity_date > l_today and nvl(disable_date, effectivity_date+1) > effectivity_date))