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 1543: p_item_group_name IN AHL_ITEM_GROUPS_VL.name%TYPE,

1539: (
1540: x_return_status OUT NOCOPY VARCHAR2,
1541: x_msg_data OUT NOCOPY VARCHAR2,
1542: p_association_type IN VARCHAR2,
1543: p_item_group_name IN AHL_ITEM_GROUPS_VL.name%TYPE,
1544: p_x_item_group_id IN OUT NOCOPY AHL_ITEM_GROUPS_VL.item_group_id%TYPE
1545: )
1546: IS
1547:

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

1540: x_return_status OUT NOCOPY VARCHAR2,
1541: x_msg_data OUT NOCOPY VARCHAR2,
1542: p_association_type IN VARCHAR2,
1543: p_item_group_name IN AHL_ITEM_GROUPS_VL.name%TYPE,
1544: p_x_item_group_id IN OUT NOCOPY AHL_ITEM_GROUPS_VL.item_group_id%TYPE
1545: )
1546: IS
1547:
1548: l_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE;

Line 1548: l_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE;

1544: p_x_item_group_id IN OUT NOCOPY AHL_ITEM_GROUPS_VL.item_group_id%TYPE
1545: )
1546: IS
1547:
1548: l_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE;
1549:
1550: CURSOR get_rec_from_value ( c_item_group_name AHL_ITEM_GROUPS_VL.name%TYPE , c_association_type VARCHAR2)
1551: IS
1552: SELECT DISTINCT item_group_id

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

1546: IS
1547:
1548: l_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE;
1549:
1550: CURSOR get_rec_from_value ( c_item_group_name AHL_ITEM_GROUPS_VL.name%TYPE , c_association_type VARCHAR2)
1551: IS
1552: SELECT DISTINCT item_group_id
1553: FROM AHL_ITEM_GROUPS_VL
1554: WHERE name = c_item_group_name

Line 1553: FROM AHL_ITEM_GROUPS_VL

1549:
1550: CURSOR get_rec_from_value ( c_item_group_name AHL_ITEM_GROUPS_VL.name%TYPE , c_association_type VARCHAR2)
1551: IS
1552: SELECT DISTINCT item_group_id
1553: FROM AHL_ITEM_GROUPS_VL
1554: WHERE name = c_item_group_name
1555: -- bug # 11833328 - sthilak - added the status=complete condition; sorao for backporting project
1556: AND status_code = 'COMPLETE'
1557: AND DECODE(c_association_type,'DISPOSITION',TYPE_CODE,'NON-TRACKED')='NON-TRACKED';

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

1555: -- bug # 11833328 - sthilak - added the status=complete condition; sorao for backporting project
1556: AND status_code = 'COMPLETE'
1557: AND DECODE(c_association_type,'DISPOSITION',TYPE_CODE,'NON-TRACKED')='NON-TRACKED';
1558:
1559: CURSOR get_rec_from_id ( c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE , c_association_type VARCHAR2)
1560: IS
1561: SELECT DISTINCT item_group_id
1562: FROM AHL_ITEM_GROUPS_VL
1563: WHERE item_group_id = c_item_group_id

Line 1562: FROM AHL_ITEM_GROUPS_VL

1558:
1559: CURSOR get_rec_from_id ( c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE , c_association_type VARCHAR2)
1560: IS
1561: SELECT DISTINCT item_group_id
1562: FROM AHL_ITEM_GROUPS_VL
1563: WHERE item_group_id = c_item_group_id
1564: -- bug # 11833328 - sthilak - added the status=complete condition; sorao for backporting project
1565: AND status_code = 'COMPLETE'
1566: AND DECODE(c_association_type,'DISPOSITION',TYPE_CODE,'NON-TRACKED')='NON-TRACKED';

Line 2171: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,

2167: PROCEDURE validate_item_uom
2168: (
2169: x_return_status OUT NOCOPY VARCHAR2,
2170: x_msg_data OUT NOCOPY VARCHAR2,
2171: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,
2172: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2173: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,
2174: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2175: )

Line 2191: c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE )

2187: AND inventory_item_id = c_inventory_item_id
2188: AND inventory_org_id = c_inventory_org_id;
2189:
2190: CURSOR get_uom_for_item_group ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,
2191: c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE )
2192: IS
2193: SELECT 'X'
2194: FROM AHL_ITEM_CLASS_UOM_V UOM, AHL_ITEM_ASSOCIATIONS_B ASSOC
2195: WHERE UOM.uom_code = c_uom_code