eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_WO_LOGIN_PVT dependencies on WIP_OPERATION_RESOURCES

Line 503: FROM WIP_OPERATION_RESOURCES WOR,

499: (select wo1.department_id from wip_operations wo1
500: where wo1.wip_entity_id = aw.wip_entity_id
501: and wo1.operation_seq_num = p_operation_seq_num) department_id,
502: WOR.resource_seq_num
503: FROM WIP_OPERATION_RESOURCES WOR,
504: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,
505: BOM_RESOURCES BRS
506: WHERE AW.workorder_id = AWO.workorder_id
507: AND WOR.wip_entity_id = AW.wip_entity_id

Line 865: FROM WIP_OPERATION_RESOURCES WOR,

861: WOR.start_date, WOR.completion_date,
862: (select wo1.department_id from wip_operations wo1
863: where wo1.wip_entity_id = aw.wip_entity_id
864: and wo1.operation_seq_num = p_operation_seq_num) department_id
865: FROM WIP_OPERATION_RESOURCES WOR,
866: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,
867: BOM_RESOURCES BRS
868: WHERE AW.workorder_id = AWO.workorder_id
869: AND AWO.operation_sequence_num = p_operation_seq_num

Line 1188: FROM WIP_OPERATION_RESOURCES WOR,

1184: WOR.resource_seq_num, WOR.start_date, WOR.completion_date,
1185: (select wo1.department_id from wip_operations wo1
1186: where wo1.wip_entity_id = aw.wip_entity_id
1187: and wo1.operation_seq_num = AWO.operation_sequence_num) department_id
1188: FROM WIP_OPERATION_RESOURCES WOR,
1189: AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO, AHL_WORKORDERS AW,
1190: BOM_RESOURCES BRS
1191: WHERE AW.workorder_id = AWO.workorder_id
1192: AND WOR.wip_entity_id = AW.wip_entity_id

Line 1487: l_resource_seq_num wip_operation_resources.resource_seq_num%TYPE;

1483: l_workorder_id NUMBER;
1484: l_org_code mtl_parameters.organization_code%TYPE;
1485: l_operation_seq_num wip_operations.operation_seq_num%TYPE;
1486:
1487: l_resource_seq_num wip_operation_resources.resource_seq_num%TYPE;
1488:
1489: l_resource_id NUMBER;
1490: l_user_role VARCHAR2(80);
1491:

Line 1777: wip_operation_resources WOR,

1773: SELECT WOR.operation_seq_num, WOR.resource_id,
1774: WOR.resource_seq_num, BRS.unit_of_measure uom_code,
1775: WO.organization_id, WO.department_id
1776: FROM wip_operations wo,
1777: wip_operation_resources WOR,
1778: bom_resources BRS
1779: WHERE wo.wip_entity_id = WOR.wip_entity_id
1780: AND wo.operation_seq_num = WOR.operation_seq_num
1781: AND WOR.resource_id = BRS.resource_id

Line 1807: wip_operation_resources WOR,

1803: SELECT WOR.operation_seq_num, WOR.resource_id,
1804: WOR.resource_seq_num, BRS.unit_of_measure uom_code,
1805: WO.organization_id, WO.department_id
1806: FROM wip_operations wo,
1807: wip_operation_resources WOR,
1808: bom_resources BRS
1809: WHERE wo.wip_entity_id = WOR.wip_entity_id
1810: AND wo.operation_seq_num = WOR.operation_seq_num
1811: AND WOR.resource_id = BRS.resource_id

Line 1839: wip_operation_resources WOR,

1835: SELECT WOR.operation_seq_num, WOR.resource_id,
1836: WOR.resource_seq_num, BRS.unit_of_measure uom_code,
1837: WO.organization_id, WO.department_id
1838: FROM wip_operations wo,
1839: wip_operation_resources WOR,
1840: bom_resources BRS
1841: WHERE wo.wip_entity_id = WOR.wip_entity_id
1842: AND wo.operation_seq_num = WOR.operation_seq_num
1843: AND WOR.resource_id = BRS.resource_id

Line 1867: wip_operation_resources WOR,

1863: CURSOR c_person_req_WO(p_wip_entity_id IN NUMBER) IS
1864: SELECT WOR.operation_seq_num, WOR.resource_id,
1865: WOR.resource_seq_num, BRS.unit_of_measure uom_code
1866: FROM wip_operations wo,
1867: wip_operation_resources WOR,
1868: bom_resources BRS
1869: WHERE wo.wip_entity_id = WOR.wip_entity_id
1870: AND wo.operation_seq_num = WOR.operation_seq_num
1871: AND WOR.resource_id = BRS.resource_id

Line 1881: wip_operation_resources WOR,

1877: p_operation_seq_num IN NUMBER) IS
1878: SELECT WOR.operation_seq_num, WOR.resource_id,
1879: WOR.resource_seq_num, BRS.unit_of_measure uom_code
1880: FROM wip_operations wo,
1881: wip_operation_resources WOR,
1882: bom_resources BRS
1883: WHERE wo.wip_entity_id = WOR.wip_entity_id
1884: AND wo.operation_seq_num = WOR.operation_seq_num
1885: AND WOR.resource_id = BRS.resource_id

Line 1897: wip_operation_resources WOR,

1893: p_resource_seq_num IN NUMBER) IS
1894: SELECT WOR.operation_seq_num, WOR.resource_id,
1895: WOR.resource_seq_num, BRS.unit_of_measure uom_code
1896: FROM wip_operations wo,
1897: wip_operation_resources WOR,
1898: bom_resources BRS
1899: WHERE wo.wip_entity_id = WOR.wip_entity_id
1900: AND wo.operation_seq_num = WOR.operation_seq_num
1901: AND WOR.resource_id = BRS.resource_id

Line 1912: FROM WIP_OPERATION_RESOURCES WOR

1908: CURSOR c_get_resrc_seq(p_wip_entity_id IN NUMBER,
1909: p_operation_seq_num IN NUMBER,
1910: p_resource_id IN NUMBER) IS
1911: SELECT WOR.resource_seq_num
1912: FROM WIP_OPERATION_RESOURCES WOR
1913: WHERE WOR.wip_entity_id = p_wip_entity_id
1914: AND WOR.operation_seq_num = p_operation_seq_num
1915: AND WOR.resource_id = p_resource_id;
1916:

Line 2657: FROM wip_operation_resources WOR,

2653: SELECT 'x'
2654: FROM wip_operations wo
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

Line 2677: FROM WIP_OPERATION_RESOURCES WOR, BOM_RESOURCES BRS

2673: SELECT 'x'
2674: FROM WIP_OPERATIONS WO
2675: WHERE wip_entity_id = p_wip_entity_id
2676: AND exists ( SELECT 'x'
2677: FROM WIP_OPERATION_RESOURCES WOR, BOM_RESOURCES BRS
2678: WHERE WOR.wip_entity_id = WO.wip_entity_id
2679: AND WOR.operation_seq_num = WO.operation_seq_num
2680: AND WOR.resource_id = BRS.resource_id
2681: AND BRS.resource_type = 2 -- person.

Line 2690: wip_operation_resources WOR,

2686: CURSOR c_check_res_multiple_wo(p_employee_id IN NUMBER,
2687: p_wip_entity_id IN NUMBER) IS
2688: SELECT 'x'
2689: FROM wip_operations wo,
2690: wip_operation_resources WOR,
2691: bom_resources BRS
2692: WHERE wo.wip_entity_id = WOR.wip_entity_id
2693: AND wo.operation_seq_num = WOR.operation_seq_num
2694: AND WOR.resource_id = BRS.resource_id

Line 2714: wip_operation_resources WOR,

2710: p_wip_entity_id IN NUMBER,
2711: p_operation_seq_num IN NUMBER) IS
2712: SELECT 'x'
2713: FROM wip_operations wo,
2714: wip_operation_resources WOR,
2715: bom_resources BRS
2716: WHERE wo.wip_entity_id = WOR.wip_entity_id
2717: AND wo.operation_seq_num = WOR.operation_seq_num
2718: AND WOR.resource_id = BRS.resource_id

Line 2746: FROM wip_operation_resources WOR, bom_resources BRS

2742: WHERE WORKORDER_ID = p_workorder_id
2743: AND OPERATION_SEQUENCE_NUM = p_op_seq_num
2744: AND status_code = 2 -- uncomplete
2745: AND exists ( SELECT 'x'
2746: FROM wip_operation_resources WOR, bom_resources BRS
2747: WHERE WOR.wip_entity_id = p_wip_entity_id
2748: AND WOR.operation_seq_num = p_op_seq_num
2749: AND WOR.resource_id = BRS.resource_id
2750: AND BRS.resource_type = 2 -- person.

Line 2763: FROM wip_operation_resources WOR,

2759: FROM wip_operations wo
2760: WHERE wo.wip_entity_id = p_wip_entity_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

Line 2793: wip_operation_resources WOR

2789: p_resource_id IN NUMBER) IS
2790:
2791: SELECT 'x'
2792: FROM wip_operations wo,
2793: wip_operation_resources WOR
2794: WHERE wo.wip_entity_id = WOR.wip_entity_id
2795: AND wo.operation_seq_num = WOR.operation_seq_num
2796: AND wo.wip_entity_id = p_wip_entity_id
2797: AND WOR.operation_seq_num = p_operation_seq_num

Line 2819: FROM WIP_OPERATION_RESOURCES WOR

2815: CURSOR c_get_resrc_id(p_wip_entity_id IN NUMBER,
2816: p_operation_seq_num IN NUMBER,
2817: p_resource_seq_num IN NUMBER) IS
2818: SELECT resource_id
2819: FROM WIP_OPERATION_RESOURCES WOR
2820: WHERE WOR.wip_entity_id = p_wip_entity_id
2821: AND WOR.operation_seq_num = p_operation_seq_num
2822: AND WOR.resource_seq_num = p_resource_seq_num;
2823: