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_OPERATIONS

Line 502: (select wo1.department_id from wip_operations wo1

498: p_resource_id IN NUMBER,
499: p_resource_seq_num IN NUMBER) IS
500:
501: SELECT AOR.OPERATION_RESOURCE_ID, WOR.start_date, WOR.completion_date,
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,

Line 528: wip_operations wo,

524: AND EXISTS (SELECT 'x'
525: FROM mtl_employees_current_view pf,
526: bom_resource_employees bre,
527: bom_dept_res_instances bdri,
528: wip_operations wo,
529: bom_department_resources bdr
530: WHERE WO.wip_entity_id = AW.wip_entity_id
531: AND WO.operation_seq_num = AWO.operation_sequence_num
532: -- AND WO.department_id = bdri.department_id

Line 865: (select wo1.department_id from wip_operations wo1

861: p_operation_seq_num IN NUMBER) IS
862:
863: SELECT AOR.OPERATION_RESOURCE_ID, WOR.resource_seq_num, WOR.resource_id,
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,

Line 888: wip_operations wo,

884: AND EXISTS (SELECT 'x'
885: FROM mtl_employees_current_view pf,
886: bom_resource_employees bre,
887: bom_dept_res_instances bdri,
888: wip_operations wo,
889: bom_department_resources bdr
890: WHERE WO.wip_entity_id = AW.wip_entity_id
891: AND WO.operation_seq_num = AWO.operation_sequence_num
892: --AND WO.department_id = bdri.department_id

Line 1188: (select wo1.department_id from wip_operations wo1

1184: p_workorder_id IN NUMBER) IS
1185:
1186: SELECT AOR.OPERATION_RESOURCE_ID, WOR.operation_seq_num, WOR.resource_id,
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,

Line 1209: wip_operations wo,

1205: AND EXISTS (SELECT 'x'
1206: FROM mtl_employees_current_view pf,
1207: bom_resource_employees bre,
1208: bom_dept_res_instances bdri,
1209: wip_operations wo,
1210: bom_department_resources bdr
1211: WHERE WO.wip_entity_id = AW.wip_entity_id
1212: AND WO.operation_seq_num = AWO.operation_sequence_num
1213: --AND WO.department_id = bdri.department_id

Line 1488: l_operation_seq_num wip_operations.operation_seq_num%TYPE;

1484: l_employee_id NUMBER;
1485: l_workorder_name wip_entities.wip_entity_name%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;

Line 1779: FROM wip_operations wo,

1775: p_wip_entity_id IN NUMBER) IS
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

Line 1809: FROM wip_operations wo,

1805: p_operation_seq_num IN NUMBER) IS
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

Line 1841: FROM wip_operations wo,

1837: p_resource_seq_num IN NUMBER) IS
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

Line 1869: FROM wip_operations wo,

1865: -- across all operations. (transit tech case).
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

Line 1883: FROM wip_operations wo,

1879: CURSOR c_person_req_OP(p_wip_entity_id IN NUMBER,
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

Line 1899: FROM wip_operations wo,

1895: p_operation_seq_num IN NUMBER,
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

Line 2662: FROM wip_operations wo

2658: -- Query to check if for a WO and its operations, any requirements exist with no qualification for given employee.
2659: CURSOR c_unqualified_for_all_ops(p_employee_id IN NUMBER,
2660: p_wip_entity_id IN NUMBER) IS
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,

Line 2682: FROM WIP_OPERATIONS WO

2678: */
2679: -- Query to check if all operations of WO have at least one person resource requirement.
2680: CURSOR c_check_res_reqd (p_wip_entity_id IN NUMBER) IS
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

Line 2697: FROM wip_operations wo,

2693: -- Query to check if employee qualifies for multiple resource requirements within an operation at a WO level.
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

Line 2721: FROM wip_operations wo,

2717: CURSOR c_check_res_multiple_op(p_employee_id IN NUMBER,
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

Line 2767: FROM wip_operations wo

2763: CURSOR c_qualified_for_one_res(p_employee_id IN NUMBER,
2764: p_wip_entity_id IN NUMBER,
2765: p_operation_seq_num IN NUMBER) IS
2766: SELECT 'x'
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,

Line 2800: FROM wip_operations wo,

2796: p_operation_seq_num IN NUMBER,
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

Line 2853: FROM WIP_OPERATIONS

2849:
2850: -- query to get all operations for a workorder.
2851: CURSOR c_get_workorder_oper (p_wip_entity_id IN NUMBER) IS
2852: SELECT operation_seq_num
2853: FROM WIP_OPERATIONS
2854: WHERE wip_entity_id = p_wip_entity_id;
2855:
2856: l_employee_id NUMBER;
2857: l_wo_status AHL_WORKORDERS.status_code%TYPE;

Line 3393: FROM WIP_OPERATIONS WO

3389:
3390: -- Query to check if all operations of WO have at least one person resource requirement.
3391: CURSOR c_check_res_reqd (p_wip_entity_id IN NUMBER) IS
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

Line 3430: FROM wip_operations wo

3426: CURSOR c_qualified_for_one_res(p_employee_id IN NUMBER,
3427: p_wip_entity_id IN NUMBER,
3428: p_operation_seq_num IN NUMBER) IS
3429: SELECT 'x'
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,

Line 3463: FROM wip_operations wo,

3459: p_operation_seq_num IN NUMBER,
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

Line 3516: FROM WIP_OPERATIONS

3512:
3513: -- query to get all operations for a workorder.
3514: CURSOR c_get_workorder_oper (p_wip_entity_id IN NUMBER) IS
3515: SELECT operation_seq_num
3516: FROM WIP_OPERATIONS
3517: WHERE wip_entity_id = p_wip_entity_id;
3518:
3519: l_employee_id NUMBER;
3520: l_wo_status AHL_WORKORDERS.status_code%TYPE;