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 506: FROM WIP_OPERATION_RESOURCES WOR,

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

Line 868: FROM WIP_OPERATION_RESOURCES WOR,

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

Line 1191: FROM WIP_OPERATION_RESOURCES WOR,

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

Line 1490: l_resource_seq_num wip_operation_resources.resource_seq_num%TYPE;

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

Line 1780: wip_operation_resources WOR,

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

Line 1810: wip_operation_resources WOR,

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

Line 1842: wip_operation_resources WOR,

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

Line 1870: wip_operation_resources WOR,

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

Line 1884: wip_operation_resources WOR,

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

Line 1900: wip_operation_resources WOR,

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

Line 1915: FROM WIP_OPERATION_RESOURCES WOR

1911: CURSOR c_get_resrc_seq(p_wip_entity_id IN NUMBER,
1912: p_operation_seq_num IN NUMBER,
1913: p_resource_id IN NUMBER) IS
1914: SELECT WOR.resource_seq_num
1915: FROM WIP_OPERATION_RESOURCES WOR
1916: WHERE WOR.wip_entity_id = p_wip_entity_id
1917: AND WOR.operation_seq_num = p_operation_seq_num
1918: AND WOR.resource_id = p_resource_id;
1919: */

Line 2665: FROM wip_operation_resources WOR,

2661: SELECT 'x'
2662: FROM wip_operations wo
2663: WHERE wo.wip_entity_id = p_wip_entity_id
2664: AND not exists ( SELECT 'x'
2665: FROM wip_operation_resources WOR,
2666: bom_resources BRS,
2667: bom_resource_employees bre,
2668: bom_dept_res_instances bdri
2669: WHERE wo.operation_seq_num = WOR.operation_seq_num

Line 2685: FROM WIP_OPERATION_RESOURCES WOR, BOM_RESOURCES BRS

2681: SELECT 'x'
2682: FROM WIP_OPERATIONS WO
2683: WHERE wip_entity_id = p_wip_entity_id
2684: AND exists ( SELECT 'x'
2685: FROM WIP_OPERATION_RESOURCES WOR, BOM_RESOURCES BRS
2686: WHERE WOR.wip_entity_id = WO.wip_entity_id
2687: AND WOR.operation_seq_num = WO.operation_seq_num
2688: AND WOR.resource_id = BRS.resource_id
2689: AND BRS.resource_type = 2 -- person.

Line 2698: wip_operation_resources WOR,

2694: CURSOR c_check_res_multiple_wo(p_employee_id IN NUMBER,
2695: p_wip_entity_id IN NUMBER) IS
2696: SELECT 'x'
2697: FROM wip_operations wo,
2698: wip_operation_resources WOR,
2699: bom_resources BRS
2700: WHERE wo.wip_entity_id = WOR.wip_entity_id
2701: AND wo.operation_seq_num = WOR.operation_seq_num
2702: AND WOR.resource_id = BRS.resource_id

Line 2722: wip_operation_resources WOR,

2718: p_wip_entity_id IN NUMBER,
2719: p_operation_seq_num IN NUMBER) IS
2720: SELECT 'x'
2721: FROM wip_operations wo,
2722: wip_operation_resources WOR,
2723: bom_resources BRS
2724: WHERE wo.wip_entity_id = WOR.wip_entity_id
2725: AND wo.operation_seq_num = WOR.operation_seq_num
2726: AND WOR.resource_id = BRS.resource_id

Line 2754: FROM wip_operation_resources WOR, bom_resources BRS

2750: WHERE WORKORDER_ID = p_workorder_id
2751: AND OPERATION_SEQUENCE_NUM = p_op_seq_num
2752: AND status_code = 2 -- uncomplete
2753: AND exists ( SELECT 'x'
2754: FROM wip_operation_resources WOR, bom_resources BRS
2755: WHERE WOR.wip_entity_id = p_wip_entity_id
2756: AND WOR.operation_seq_num = p_op_seq_num
2757: AND WOR.resource_id = BRS.resource_id
2758: AND BRS.resource_type = 2 -- person.

Line 2771: FROM wip_operation_resources WOR,

2767: FROM wip_operations wo
2768: WHERE wo.wip_entity_id = p_wip_entity_id
2769: and wo.operation_seq_num = p_operation_seq_num
2770: AND exists ( SELECT 'x'
2771: FROM wip_operation_resources WOR,
2772: bom_resources BRS,
2773: bom_resource_employees bre,
2774: bom_dept_res_instances bdri,
2775: bom_department_resources bdr

Line 2801: wip_operation_resources WOR

2797: p_resource_id IN NUMBER) IS
2798:
2799: SELECT 'x'
2800: FROM wip_operations wo,
2801: wip_operation_resources WOR
2802: WHERE wo.wip_entity_id = WOR.wip_entity_id
2803: AND wo.operation_seq_num = WOR.operation_seq_num
2804: AND wo.wip_entity_id = p_wip_entity_id
2805: AND WOR.operation_seq_num = p_operation_seq_num

Line 2827: FROM WIP_OPERATION_RESOURCES WOR

2823: CURSOR c_get_resrc_id(p_wip_entity_id IN NUMBER,
2824: p_operation_seq_num IN NUMBER,
2825: p_resource_seq_num IN NUMBER) IS
2826: SELECT resource_id
2827: FROM WIP_OPERATION_RESOURCES WOR
2828: WHERE WOR.wip_entity_id = p_wip_entity_id
2829: AND WOR.operation_seq_num = p_operation_seq_num
2830: AND WOR.resource_seq_num = p_resource_seq_num;
2831:

Line 3396: FROM WIP_OPERATION_RESOURCES WOR, BOM_RESOURCES BRS

3392: SELECT 'x'
3393: FROM WIP_OPERATIONS WO
3394: WHERE wip_entity_id = p_wip_entity_id
3395: AND exists ( SELECT 'x'
3396: FROM WIP_OPERATION_RESOURCES WOR, BOM_RESOURCES BRS
3397: WHERE WOR.wip_entity_id = WO.wip_entity_id
3398: AND WOR.operation_seq_num = WO.operation_seq_num
3399: AND WOR.resource_id = BRS.resource_id
3400: AND BRS.resource_type = 2 -- person.

Line 3417: FROM wip_operation_resources WOR, bom_resources BRS

3413: WHERE WORKORDER_ID = p_workorder_id
3414: AND OPERATION_SEQUENCE_NUM = p_op_seq_num
3415: AND status_code = 2 -- uncomplete
3416: AND exists ( SELECT 'x'
3417: FROM wip_operation_resources WOR, bom_resources BRS
3418: WHERE WOR.wip_entity_id = p_wip_entity_id
3419: AND WOR.operation_seq_num = p_op_seq_num
3420: AND WOR.resource_id = BRS.resource_id
3421: AND BRS.resource_type = 2 -- person.

Line 3434: FROM wip_operation_resources WOR,

3430: FROM wip_operations wo
3431: WHERE wo.wip_entity_id = p_wip_entity_id
3432: and wo.operation_seq_num = p_operation_seq_num
3433: AND exists ( SELECT 'x'
3434: FROM wip_operation_resources WOR,
3435: bom_resources BRS,
3436: bom_resource_employees bre,
3437: bom_dept_res_instances bdri,
3438: bom_department_resources bdr

Line 3464: wip_operation_resources WOR

3460: p_resource_id IN NUMBER) IS
3461:
3462: SELECT 'x'
3463: FROM wip_operations wo,
3464: wip_operation_resources WOR
3465: WHERE wo.wip_entity_id = WOR.wip_entity_id
3466: AND wo.operation_seq_num = WOR.operation_seq_num
3467: AND wo.wip_entity_id = p_wip_entity_id
3468: AND WOR.operation_seq_num = p_operation_seq_num

Line 3490: FROM WIP_OPERATION_RESOURCES WOR

3486: CURSOR c_get_resrc_id(p_wip_entity_id IN NUMBER,
3487: p_operation_seq_num IN NUMBER,
3488: p_resource_seq_num IN NUMBER) IS
3489: SELECT resource_id
3490: FROM WIP_OPERATION_RESOURCES WOR
3491: WHERE WOR.wip_entity_id = p_wip_entity_id
3492: AND WOR.operation_seq_num = p_operation_seq_num
3493: AND WOR.resource_seq_num = p_resource_seq_num;
3494: