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 BOM_RESOURCES

Line 505: BOM_RESOURCES BRS

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
508: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
509: AND WOR.OPERATION_SEQ_NUM = AWO.OPERATION_SEQUENCE_NUM

Line 867: BOM_RESOURCES BRS

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
870: AND WOR.wip_entity_id = AW.wip_entity_id
871: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM

Line 1190: BOM_RESOURCES BRS

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
1193: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1194: AND WOR.OPERATION_SEQ_NUM = AWO.OPERATION_SEQUENCE_NUM

Line 1778: bom_resources BRS

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
1782: AND BRS.resource_type = 2 -- person.

Line 1808: bom_resources BRS

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
1812: AND BRS.resource_type = 2 -- person.

Line 1840: bom_resources BRS

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
1844: AND BRS.resource_type = 2 -- person.

Line 1868: bom_resources BRS

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
1872: AND BRS.resource_type = 2 -- person.

Line 1882: bom_resources BRS

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
1886: AND BRS.resource_type = 2 -- person.

Line 1898: bom_resources BRS

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
1902: AND BRS.resource_type = 2 -- person.

Line 2658: bom_resources BRS,

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
2662: AND WOR.resource_id = BRS.resource_id

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 2691: bom_resources BRS

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
2695: AND BRS.resource_type = 2 -- person.

Line 2715: bom_resources BRS

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
2719: AND BRS.resource_type = 2 -- person.

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 2764: bom_resources BRS,

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
2768: WHERE WOR.operation_seq_num = wo.operation_seq_num

Line 2829: FROM BOM_RESOURCES

2825: -- query to validate resource_id. Resource must be of type 'person'.
2826: CURSOR c_is_resource_valid(p_resource_id IN NUMBER,
2827: p_org_id IN NUMBER) IS
2828: SELECT resource_code
2829: FROM BOM_RESOURCES
2830: WHERE RESOURCE_ID = p_resource_id
2831: AND organization_id = p_org_id
2832: AND resource_type = 2;
2833:

Line 2855: l_resource_code BOM_RESOURCES.resource_code%TYPE;

2851: l_wip_entity_id NUMBER;
2852: l_org_id NUMBER;
2853:
2854: --l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
2855: l_resource_code BOM_RESOURCES.resource_code%TYPE;
2856:
2857: l_junk VARCHAR2(1);
2858: l_return_status VARCHAR2(1);
2859: l_msg_count NUMBER;