APPS.BOM_VALIDATE_OP_RES dependencies on BOM_SUB_OPERATION_RESOURCES

Line 1227: from bom_sub_operation_resources

1223: Cursor Check2 (l_sgn number) is
1224: select substitute_group_num,
1225: min(schedule_seq_num) mn_ssn2, --min(resource_seq_num) mn_rsn2,
1226: max(schedule_seq_num) mx_ssn2 --max(resource_seq_num) mx_rsn2
1227: from bom_sub_operation_resources
1228: where operation_sequence_id = p_op_seq_id
1229: and substitute_group_num = l_sgn
1230: group by substitute_group_num
1231: order by substitute_group_num;

Line 2109: FROM BOM_SUB_OPERATION_RESOURCES

2105: IS
2106: SELECT 'Sub Res Exists'
2107: FROM SYS.DUAL
2108: WHERE EXISTS ( SELECT NULL
2109: FROM BOM_SUB_OPERATION_RESOURCES
2110: WHERE operation_sequence_id = p_op_seq_id
2111: AND substitute_group_num = p_sub_group_num )
2112: AND NOT EXISTS ( SELECT NULL
2113: FROM BOM_OPERATION_RESOURCES

Line 2126: FROM BOM_SUB_OPERATION_RESOURCES bsor

2122: IS
2123: SELECT 'Sub Res Exists'
2124: FROM SYS.DUAL
2125: WHERE EXISTS ( SELECT NULL
2126: FROM BOM_SUB_OPERATION_RESOURCES bsor
2127: , BOM_OPERATION_SEQUENCES bos
2128: WHERE bsor.substitute_group_num = p_sub_group_num
2129: AND bsor.operation_sequence_id = bos.old_operation_sequence_id
2130: AND bos.operation_sequence_id = p_op_seq_id )

Line 2148: FROM BOM_SUB_OPERATION_RESOURCES

2144: IS
2145: SELECT 'Sub PO Move Exists'
2146: FROM SYS.DUAL
2147: WHERE EXISTS ( SELECT NULL
2148: FROM BOM_SUB_OPERATION_RESOURCES
2149: WHERE autocharge_type = l_PO_MOVE
2150: AND substitute_group_num = p_sub_group_num
2151: AND operation_sequence_id = p_op_seq_id ) ;
2152:

Line 2159: FROM BOM_SUB_OPERATION_RESOURCES bsor

2155: IS
2156: SELECT 'Sub PO Move Exists'
2157: FROM SYS.DUAL
2158: WHERE EXISTS ( SELECT NULL
2159: FROM BOM_SUB_OPERATION_RESOURCES bsor
2160: , BOM_OPERATION_SEQUENCES bos
2161: WHERE autocharge_type = l_PO_MOVE
2162: AND bsor.substitute_group_num = p_sub_group_num
2163: AND bsor.operation_sequence_id = bos.old_operation_sequence_id

Line 2176: FROM BOM_SUB_OPERATION_RESOURCES

2172: IS
2173: SELECT 'Sub PO Move Exists'
2174: FROM SYS.DUAL
2175: WHERE EXISTS ( SELECT NULL
2176: FROM BOM_SUB_OPERATION_RESOURCES
2177: WHERE schedule_flag = p_schedule_flag
2178: AND substitute_group_num = p_sub_group_num
2179: AND operation_sequence_id = p_op_seq_id ) ;
2180:

Line 2189: FROM BOM_SUB_OPERATION_RESOURCES bsor

2185: IS
2186: SELECT 'Sub PO Move Exists'
2187: FROM SYS.DUAL
2188: WHERE EXISTS ( SELECT NULL
2189: FROM BOM_SUB_OPERATION_RESOURCES bsor
2190: , BOM_OPERATION_SEQUENCES bos
2191: WHERE bsor.schedule_flag = p_schedule_flag
2192: AND bsor.substitute_group_num = p_sub_group_num
2193: AND bsor.operation_sequence_id = bos.old_operation_sequence_id

Line 3539: FROM bom_sub_operation_resources

3535: AND rownum=1;
3536:
3537: CURSOR l_sch_sub_res_cur IS
3538: SELECT resource_id
3539: FROM bom_sub_operation_resources
3540: WHERE operation_sequence_id = p_op_seq_id
3541: AND schedule_seq_num = nvl(p_sch_seq_num,p_res_seq_num)
3542: AND schedule_flag not in (p_sch_flag,l_NO_SCHEDULE)
3543: AND rownum=1;