APPS.BOM_VALIDATE_OP_SEQ dependencies on BOM_OPERATIONAL_ROUTINGS

Line 57: FROM bom_operational_routings

53: CURSOR l_primary_rtg_csr ( p_revised_item_id NUMBER
54: ,p_organization_id NUMBER )
55: IS
56: SELECT 'Primary not Exists'
57: FROM bom_operational_routings
58: WHERE assembly_item_id = p_revised_item_id
59: AND organization_id = p_organization_id
60: AND NVL(alternate_routing_designator, 'NONE') = 'NONE' ;
61:

Line 652: FROM bom_operational_routings

648: IS
649:
650: CURSOR l_get_common_cur (p_routing_sequence_id NUMBER) IS
651: SELECT 'common exists'
652: FROM bom_operational_routings
653: WHERE common_routing_sequence_id <> routing_sequence_id
654: AND routing_sequence_id = p_routing_sequence_id ;
655:
656:

Line 2382: , bom_operational_routings bor

2378: SELECT 'Std Op Invalid'
2379: FROM DUAL
2380: WHERE NOT EXISTS (SELECT NULL
2381: FROM BOM_STANDARD_OPERATIONS bso
2382: , bom_operational_routings bor
2383: WHERE NVL(bso.operation_type,1 )
2384: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
2385: , NVL(p_op_type, 1))
2386: AND NVL(bso.line_id, FND_API.G_MISS_NUM)

Line 2403: (SELECT 1 FROM BOM_OPERATIONAL_ROUTINGS

2399: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)
2400: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)
2401: -- AND BOM_Rtg_Globals.Get_Routing_Sequence_Id IS NULL
2402: AND NOT EXISTS -- Added for bug 3578057, to check if it is a new routing being created through the ECO
2403: (SELECT 1 FROM BOM_OPERATIONAL_ROUTINGS
2404: WHERE routing_sequence_id = p_rtg_seq_id)
2405: AND eri.revised_item_sequence_id = p_rit_seq_id
2406: AND bso.department_id = p_dept_id
2407: AND bso.organization_id = p_org_id

Line 2950: FROM bom_operational_routings

2946: CURSOR l_rtg_cur (p_rtg_seq_id NUMBER) IS
2947: SELECT 'implemented'
2948: FROM DUAL
2949: WHERE EXISTS ( SELECT NULL
2950: FROM bom_operational_routings
2951: WHERE common_routing_sequence_id <> p_rtg_seq_id
2952: ) ;
2953:
2954: -- Check if Parent Operation has resource

Line 3105: FROM bom_operational_routings bor

3101: WHERE NOT EXISTS ( SELECT NULL
3102: FROM BOM_OPERATION_SEQUENCES bos
3103: WHERE routing_sequence_id =
3104: ( SELECT common_routing_sequence_id
3105: FROM bom_operational_routings bor
3106: WHERE routing_sequence_id = p_rtg_seq_id
3107: )
3108: AND bos.effectivity_date <= p_effectivity_date
3109: AND NVL(bos.disable_date,p_effectivity_date+1)

Line 3143: FROM BOM_OPERATIONAL_ROUTINGS

3139: AND bos.operation_sequence_id = p_old_op_seq_id
3140: ) ;
3141: CURSOR get_ssos_csr (p_rtg_seq_id NUMBER) IS
3142: SELECT serialization_start_op
3143: FROM BOM_OPERATIONAL_ROUTINGS
3144: WHERE routing_sequence_id = p_rtg_seq_id
3145: AND serialization_start_op IS NOT NULL;
3146:
3147: BEGIN