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_WORKORDER_PVT dependencies on BOM_DEPARTMENTS

Line 663: FROM BOM_DEPARTMENTS

659:
660: CURSOR get_department(c_dept VARCHAR2,c_org_id NUMBER)
661: IS
662: SELECT department_id
663: FROM BOM_DEPARTMENTS
664: WHERE UPPER(description) LIKE UPPER(c_dept)
665: AND ORganization_id=c_org_id;
666: -- bug 4143943
667: CURSOR get_wo_status(c_workorder_id NUMBER)

Line 986: FROM BOM_DEPARTMENTS a

982:
983: CURSOR validate_dept(c_dept_id NUMBER,c_org_id NUMBER)
984: IS
985: SELECT a.department_id
986: FROM BOM_DEPARTMENTS a
987: WHERE a.department_id=c_dept_id
988: AND a.organization_id=c_org_id;
989:
990: CURSOR validate_item_instance(c_inv_item_id NUMBER,c_inst_id NUMBER)

Line 1538: BOM_RESOURCES BR, BOM_DEPARTMENTS DEPT

1534: p_org_id IN NUMBER)
1535: IS
1536: SELECT DISTINCT MAP.department_id, DEPT.description
1537: FROM BOM_DEPARTMENT_RESOURCES BD, AHL_RESOURCE_MAPPINGS MAP,
1538: BOM_RESOURCES BR, BOM_DEPARTMENTS DEPT
1539: WHERE BD.resource_id = MAP.bom_resource_id
1540: AND BR.resource_id = BD.resource_id
1541: AND BR.organization_id = p_org_id
1542: AND MAP.aso_resource_id = p_aso_resource_id

Line 1548: l_department_name bom_departments.description%TYPE;

1544: AND MAP.department_id = BD.department_id
1545: AND BD.department_id = dept.department_id;
1546:
1547: l_department_id NUMBER;
1548: l_department_name bom_departments.description%TYPE;
1549:
1550:
1551: BEGIN
1552:

Line 1604: l_final_department_name bom_departments.description%TYPE;

1600:
1601: l_rt_oper_resource_rec get_rt_oper_resources%ROWTYPE;
1602: l_return_status varchar2(1);
1603: l_final_department_id NUMBER;
1604: l_final_department_name bom_departments.description%TYPE;
1605: l_department_id NUMBER;
1606: l_department_name bom_departments.description%TYPE;
1607:
1608:

Line 1606: l_department_name bom_departments.description%TYPE;

1602: l_return_status varchar2(1);
1603: l_final_department_id NUMBER;
1604: l_final_department_name bom_departments.description%TYPE;
1605: l_department_id NUMBER;
1606: l_department_name bom_departments.description%TYPE;
1607:
1608:
1609: BEGIN
1610:

Line 2694: l_department_name bom_departments.description%TYPE;

2690: l_blank_operation_txt FND_NEW_MESSAGES.message_text%TYPE;
2691:
2692: -- Added for FP bug# 7238868
2693: l_department_id NUMBER;
2694: l_department_name bom_departments.description%TYPE;
2695: l_route_found VARCHAR2(1);
2696: l_oper_found VARCHAR2(1);
2697: l_return_status VARCHAR2(1);
2698:

Line 3531: l_department_name bom_departments.description%TYPE;

3527: -- Bug # 6680137 -- end
3528:
3529: -- Added for FP bug# 7238868
3530: l_department_id NUMBER;
3531: l_department_name bom_departments.description%TYPE;
3532: l_oper_found VARCHAR2(1);
3533:
3534: CURSOR get_operation_details(p_operation_code VARCHAR2)
3535: IS