DBA Data[Home] [Help]

APPS.FLM_COPY_ROUTING dependencies on BOM_OPERATION_SEQUENCES_V

Line 390: From bom_operation_sequences_v bosv

386: ,NULL Delete_Group_Name
387: ,NULL DG_Description
388: ,bosv.OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
389: ,bosv.STANDARD_OPERATION_ID STANDARD_OPERATION_ID
390: From bom_operation_sequences_v bosv
391: Where bosv.routing_sequence_id = p_routing_sequence_id
392: and ((bosv.effectivity_date <= l_today and nvl(bosv.disable_date,l_today+1) > l_today)
393: or (bosv.effectivity_date > l_today and nvl(bosv.disable_date, bosv.effectivity_date+1) > bosv.effectivity_date))
394: Order by bosv.operation_type desc;

Line 550: From bom_operation_sequences_v bosv

546: Cursor c_std_ops(p_routing_sequence_id number) Is
547: Select distinct standard_operation_id
548: ,standard_operation_code
549: ,operation_type
550: From bom_operation_sequences_v bosv
551: Where routing_sequence_id = p_routing_sequence_id
552: and ((effectivity_date <= l_today and nvl(disable_date,l_today+1) > l_today)
553: or (effectivity_date > l_today and nvl(disable_date, effectivity_date+1) > effectivity_date))
554: Order by standard_operation_code;