APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_ITEM_GROUPS_B

Line 66: FROM ahl_item_groups_b

62: --end performance tuning
63:
64: CURSOR get_item_group_id(c_item_group_name VARCHAR2) IS
65: SELECT item_group_id
66: FROM ahl_item_groups_b
67: WHERE name = c_item_group_name;
68:
69: CURSOR check_inv_item_id(c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
70: SELECT inventory_item_id

Line 908: AHL_ITEM_GROUPS_B GRP,

904: AHL_PRD_DISPOSITIONS_tl displ,
905: AHL_MC_PATH_POSITIONS pp,
906: MTL_SYSTEM_ITEMS_KFV MTL,
907: CSI_ITEM_INSTANCES CSI,
908: AHL_ITEM_GROUPS_B GRP,
909: MTL_MATERIAL_STATUSES_TL COND,
910: CS_INCIDENTS_ALL_B INC,
911: CS_INCIDENTS_ALL_TL INCL,
912: CS_INCIDENT_SEVERITIES_TL SEV,

Line 1058: AHL_ITEM_GROUPS_B GRP,

1054: CS_INCIDENT_SEVERITIES_TL SEV,
1055: FND_LOOKUP_VALUES PCODE,
1056: MTL_SYSTEM_ITEMS_KFV MTL,
1057: CSI_ITEM_INSTANCES CSI,
1058: AHL_ITEM_GROUPS_B GRP,
1059: MTL_MATERIAL_STATUSES_TL COND,
1060: FND_LOOKUP_VALUES FND1,
1061: FND_LOOKUP_VALUES FND2,
1062: FND_LOOKUP_VALUES FND3

Line 1204: AHL_ITEM_GROUPS_B GRP,

1200: FND_LOOKUP_VALUES FND1,
1201: FND_LOOKUP_VALUES FND2,
1202: FND_LOOKUP_VALUES FND3,
1203: MTL_MATERIAL_STATUSES_TL COND,
1204: AHL_ITEM_GROUPS_B GRP,
1205: MTL_SYSTEM_ITEMS_KFV MTL,
1206: CSI_ITEM_INSTANCES CSI,
1207: CS_INCIDENTS_ALL_B INC,
1208: CS_INCIDENTS_ALL_TL INCL,