[Home] [Help]
519: AND WOR.resource_seq_num = nvl(p_resource_seq_num, WOR.resource_seq_num)
520: -- qualified.
521: AND EXISTS (SELECT 'x'
522: FROM mtl_employees_current_view pf,
523: bom_resource_employees bre,
524: bom_dept_res_instances bdri,
525: wip_operations wo,
526: bom_department_resources bdr
527: WHERE WO.wip_entity_id = AW.wip_entity_id
879: AND AW.workorder_id = p_workorder_id
880: -- qualified.
881: AND EXISTS (SELECT 'x'
882: FROM mtl_employees_current_view pf,
883: bom_resource_employees bre,
884: bom_dept_res_instances bdri,
885: wip_operations wo,
886: bom_department_resources bdr
887: WHERE WO.wip_entity_id = AW.wip_entity_id
1200: AND AW.workorder_id = p_workorder_id
1201: -- qualified.
1202: AND EXISTS (SELECT 'x'
1203: FROM mtl_employees_current_view pf,
1204: bom_resource_employees bre,
1205: bom_dept_res_instances bdri,
1206: wip_operations wo,
1207: bom_department_resources bdr
1208: WHERE WO.wip_entity_id = AW.wip_entity_id
1781: AND WOR.resource_id = BRS.resource_id
1782: AND BRS.resource_type = 2 -- person.
1783: AND wo.wip_entity_id = p_wip_entity_id
1784: AND exists ( SELECT 'x'
1785: FROM bom_resource_employees bre,
1786: bom_dept_res_instances bdri,
1787: bom_department_resources bdr
1788: WHERE --WO.department_id = bdri.department_id
1789: nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id
1812: AND BRS.resource_type = 2 -- person.
1813: AND wo.wip_entity_id = p_wip_entity_id
1814: AND wo.operation_seq_num = p_operation_seq_num
1815: AND exists ( SELECT 'x'
1816: FROM bom_resource_employees bre,
1817: bom_dept_res_instances bdri,
1818: bom_department_resources bdr
1819: WHERE --WO.department_id = bdri.department_id
1820: nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id
1845: AND wo.wip_entity_id = p_wip_entity_id
1846: AND wo.operation_seq_num = p_operation_seq_num
1847: AND WOR.resource_seq_num = p_resource_seq_num
1848: AND exists ( SELECT 'x'
1849: FROM bom_resource_employees bre,
1850: bom_dept_res_instances bdri,
1851: bom_department_resources bdr
1852: WHERE --WO.department_id = bdri.department_id
1853: nvl(bdr.share_from_dept_id, WO.department_id) = bdri.department_id
2655: WHERE wo.wip_entity_id = p_wip_entity_id
2656: AND not exists ( SELECT 'x'
2657: FROM wip_operation_resources WOR,
2658: bom_resources BRS,
2659: bom_resource_employees bre,
2660: bom_dept_res_instances bdri
2661: WHERE wo.operation_seq_num = WOR.operation_seq_num
2662: AND WOR.resource_id = BRS.resource_id
2663: AND BRS.resource_type = 2 -- person.
2694: AND WOR.resource_id = BRS.resource_id
2695: AND BRS.resource_type = 2 -- person.
2696: AND wo.wip_entity_id = p_wip_entity_id
2697: AND exists ( SELECT 'x'
2698: FROM bom_resource_employees bre,
2699: bom_dept_res_instances bdri
2700: WHERE WO.department_id = bdri.department_id
2701: AND WOR.RESOURCE_ID= bdri.resource_id
2702: AND bre.instance_id = bdri.instance_id
2719: AND BRS.resource_type = 2 -- person.
2720: AND wo.wip_entity_id = p_wip_entity_id
2721: AND wo.operation_seq_num = p_operation_seq_num
2722: AND exists ( SELECT 'x'
2723: FROM bom_resource_employees bre,
2724: bom_dept_res_instances bdri
2725: WHERE WO.department_id = bdri.department_id
2726: AND WOR.RESOURCE_ID= bdri.resource_id
2727: AND bre.instance_id = bdri.instance_id
2761: and wo.operation_seq_num = p_operation_seq_num
2762: AND exists ( SELECT 'x'
2763: FROM wip_operation_resources WOR,
2764: bom_resources BRS,
2765: bom_resource_employees bre,
2766: bom_dept_res_instances bdri,
2767: bom_department_resources bdr
2768: WHERE WOR.operation_seq_num = wo.operation_seq_num
2769: AND WOR.wip_entity_id = wo.wip_entity_id
2796: AND wo.wip_entity_id = p_wip_entity_id
2797: AND WOR.operation_seq_num = p_operation_seq_num
2798: AND WOR.resource_id = p_resource_id
2799: AND not exists ( SELECT 'x'
2800: FROM bom_resource_employees bre,
2801: bom_dept_res_instances bdri,
2802: bom_department_resources bdr
2803: WHERE bre.resource_id = wor.resource_id
2804: AND bre.organization_id = wor.organization_id