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 475: FROM bom_operation_resources

471: l_resource_id number;
472:
473: CURSOR l_sch_res_cur IS
474: SELECT resource_id
475: FROM bom_operation_resources
476: WHERE operation_sequence_id = p_op_seq_id
477: AND nvl(schedule_seq_num,resource_seq_num) = p_sch_seq_num
478: AND schedule_flag not in (p_sch_flag,l_NO_SCHEDULE)
479: AND rownum=1;