APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_GROUPS_VL

Line 2836: From ahl_item_groups_vl

2832: Select Name,
2833: Status_code,
2834: Object_version_number,
2835: source_item_group_id
2836: From ahl_item_groups_vl
2837: Where item_group_id = c_itemgroup_id;
2838:
2839: CURSOR validate_item_group(c_itemgroup_id NUMBER)
2840: is

Line 3205: from ahl_item_groups_vl

3201: attribute12 ,
3202: attribute13 ,
3203: attribute14 ,
3204: attribute15
3205: from ahl_item_groups_vl
3206: Where Item_Group_id = c_itemgroup_id;
3207:
3208: l_itemgroups_det get_itemgroup_det%rowtype;
3209:

Line 3248: from ahl_item_groups_vl

3244:
3245: cursor get_revision_info(c_itemgroup_id in Number)
3246: is
3247: Select 'x'
3248: from ahl_item_groups_vl
3249: where source_item_group_id = c_itemgroup_id and
3250: status_code <> 'COMPLETE';
3251:
3252: l_dummy VARCHAR2(1);

Line 3838: from ahl_item_groups_vl

3834: attribute12 ,
3835: attribute13 ,
3836: attribute14 ,
3837: attribute15
3838: from ahl_item_groups_vl
3839: Where Item_Group_id = c_itemgroup_id;
3840:
3841: l_itemgroup_det get_itemgroup_det%rowType;
3842: