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 508: BOM_RESOURCES BRS

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

Line 870: BOM_RESOURCES BRS

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

Line 1193: BOM_RESOURCES BRS

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

Line 1781: bom_resources BRS

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

Line 1811: bom_resources BRS

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

Line 1843: bom_resources BRS

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

Line 1871: bom_resources BRS

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

Line 1885: bom_resources BRS

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

Line 1901: bom_resources BRS

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

Line 2666: bom_resources BRS,

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

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

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

Line 2723: bom_resources BRS

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

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

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

Line 2837: FROM BOM_RESOURCES

2833: -- query to validate resource_id. Resource must be of type 'person'.
2834: CURSOR c_is_resource_valid(p_resource_id IN NUMBER,
2835: p_org_id IN NUMBER) IS
2836: SELECT resource_code
2837: FROM BOM_RESOURCES
2838: WHERE RESOURCE_ID = p_resource_id
2839: AND organization_id = p_org_id
2840: AND resource_type = 2;
2841:

Line 2863: l_resource_code BOM_RESOURCES.resource_code%TYPE;

2859: l_wip_entity_id NUMBER;
2860: l_org_id NUMBER;
2861:
2862: --l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
2863: l_resource_code BOM_RESOURCES.resource_code%TYPE;
2864:
2865: l_junk VARCHAR2(1);
2866: l_return_status VARCHAR2(1);
2867: l_msg_count NUMBER;

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

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

Line 3500: FROM BOM_RESOURCES

3496: -- query to validate resource_id. Resource must be of type 'person'.
3497: CURSOR c_is_resource_valid(p_resource_id IN NUMBER,
3498: p_org_id IN NUMBER) IS
3499: SELECT resource_code
3500: FROM BOM_RESOURCES
3501: WHERE RESOURCE_ID = p_resource_id
3502: AND organization_id = p_org_id
3503: AND resource_type = 2;
3504:

Line 3526: l_resource_code BOM_RESOURCES.resource_code%TYPE;

3522: l_wip_entity_id NUMBER;
3523: l_org_id NUMBER;
3524:
3525: --l_oper_status AHL_WORKORDER_OPERATIONS.status_code%TYPE;
3526: l_resource_code BOM_RESOURCES.resource_code%TYPE;
3527:
3528: l_junk VARCHAR2(1);
3529: l_return_status VARCHAR2(1);
3530: l_msg_count NUMBER;