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_RM_ROUTE_UTIL dependencies on AHL_ITEM_GROUPS_VL

Line 1464: p_item_group_name IN AHL_ITEM_GROUPS_VL.name%TYPE,

1460: (
1461: x_return_status OUT NOCOPY VARCHAR2,
1462: x_msg_data OUT NOCOPY VARCHAR2,
1463: p_association_type IN VARCHAR2,
1464: p_item_group_name IN AHL_ITEM_GROUPS_VL.name%TYPE,
1465: p_x_item_group_id IN OUT NOCOPY AHL_ITEM_GROUPS_VL.item_group_id%TYPE
1466: )
1467: IS
1468:

Line 1465: p_x_item_group_id IN OUT NOCOPY AHL_ITEM_GROUPS_VL.item_group_id%TYPE

1461: x_return_status OUT NOCOPY VARCHAR2,
1462: x_msg_data OUT NOCOPY VARCHAR2,
1463: p_association_type IN VARCHAR2,
1464: p_item_group_name IN AHL_ITEM_GROUPS_VL.name%TYPE,
1465: p_x_item_group_id IN OUT NOCOPY AHL_ITEM_GROUPS_VL.item_group_id%TYPE
1466: )
1467: IS
1468:
1469: l_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE;

Line 1469: l_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE;

1465: p_x_item_group_id IN OUT NOCOPY AHL_ITEM_GROUPS_VL.item_group_id%TYPE
1466: )
1467: IS
1468:
1469: l_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE;
1470:
1471: CURSOR get_rec_from_value ( c_item_group_name AHL_ITEM_GROUPS_VL.name%TYPE , c_association_type VARCHAR2)
1472: IS
1473: SELECT DISTINCT item_group_id

Line 1471: CURSOR get_rec_from_value ( c_item_group_name AHL_ITEM_GROUPS_VL.name%TYPE , c_association_type VARCHAR2)

1467: IS
1468:
1469: l_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE;
1470:
1471: CURSOR get_rec_from_value ( c_item_group_name AHL_ITEM_GROUPS_VL.name%TYPE , c_association_type VARCHAR2)
1472: IS
1473: SELECT DISTINCT item_group_id
1474: FROM AHL_ITEM_GROUPS_VL
1475: WHERE name = c_item_group_name

Line 1474: FROM AHL_ITEM_GROUPS_VL

1470:
1471: CURSOR get_rec_from_value ( c_item_group_name AHL_ITEM_GROUPS_VL.name%TYPE , c_association_type VARCHAR2)
1472: IS
1473: SELECT DISTINCT item_group_id
1474: FROM AHL_ITEM_GROUPS_VL
1475: WHERE name = c_item_group_name
1476: AND DECODE(c_association_type,'DISPOSITION',TYPE_CODE,'NON-TRACKED')='NON-TRACKED';
1477:
1478: CURSOR get_rec_from_id ( c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE , c_association_type VARCHAR2)

Line 1478: CURSOR get_rec_from_id ( c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE , c_association_type VARCHAR2)

1474: FROM AHL_ITEM_GROUPS_VL
1475: WHERE name = c_item_group_name
1476: AND DECODE(c_association_type,'DISPOSITION',TYPE_CODE,'NON-TRACKED')='NON-TRACKED';
1477:
1478: CURSOR get_rec_from_id ( c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE , c_association_type VARCHAR2)
1479: IS
1480: SELECT DISTINCT item_group_id
1481: FROM AHL_ITEM_GROUPS_VL
1482: WHERE item_group_id = c_item_group_id

Line 1481: FROM AHL_ITEM_GROUPS_VL

1477:
1478: CURSOR get_rec_from_id ( c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE , c_association_type VARCHAR2)
1479: IS
1480: SELECT DISTINCT item_group_id
1481: FROM AHL_ITEM_GROUPS_VL
1482: WHERE item_group_id = c_item_group_id
1483: AND DECODE(c_association_type,'DISPOSITION',TYPE_CODE,'NON-TRACKED')='NON-TRACKED';
1484:
1485: BEGIN

Line 2039: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,

2035: PROCEDURE validate_item_uom
2036: (
2037: x_return_status OUT NOCOPY VARCHAR2,
2038: x_msg_data OUT NOCOPY VARCHAR2,
2039: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,
2040: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2041: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,
2042: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2043: )

Line 2059: c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE )

2055: AND inventory_item_id = c_inventory_item_id
2056: AND inventory_org_id = c_inventory_org_id;
2057:
2058: CURSOR get_uom_for_item_group ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,
2059: c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE )
2060: IS
2061: SELECT 'X'
2062: FROM AHL_ITEM_CLASS_UOM_V UOM, AHL_ITEM_ASSOCIATIONS_B ASSOC
2063: WHERE UOM.uom_code = c_uom_code