APPS.BOM_VALIDATE_SUB_OP_RES dependencies on BOM_OPERATION_RESOURCES

Line 255: FROM BOM_OPERATION_RESOURCES

251: IS
252: SELECT 'Related Schedule Resource does not exist'
253: FROM SYS.DUAL
254: WHERE NOT EXISTS( SELECT NULL
255: FROM BOM_OPERATION_RESOURCES
256: WHERE schedule_flag = p_schedule_flag
257: AND substitute_group_num = p_sub_group_num
258: AND operation_sequence_id = p_op_seq_id
259: ) ;

Line 324: FROM BOM_OPERATION_RESOURCES

320: IS
321: SELECT 'Related PO Move Resource does not exist'
322: FROM SYS.DUAL
323: WHERE NOT EXISTS( SELECT NULL
324: FROM BOM_OPERATION_RESOURCES
325: WHERE autocharge_type = l_PO_MOVE
326: AND substitute_group_num = p_sub_group_num
327: AND operation_sequence_id = p_op_seq_id
328: ) ;

Line 470: FROM bom_operation_resources

466: l_resource_id number;
467:
468: CURSOR l_sch_res_cur IS
469: SELECT resource_id
470: FROM bom_operation_resources
471: WHERE operation_sequence_id = p_op_seq_id
472: AND nvl(schedule_seq_num,resource_seq_num) = p_sch_seq_num
473: AND schedule_flag not in (p_sch_flag,l_NO_SCHEDULE)
474: AND rownum=1;