APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_GROUPS_VL

Line 2846: From ahl_item_groups_vl

2842: Select Name,
2843: Status_code,
2844: Object_version_number,
2845: source_item_group_id
2846: From ahl_item_groups_vl
2847: Where item_group_id = c_itemgroup_id;
2848:
2849: CURSOR validate_item_group(c_itemgroup_id NUMBER)
2850: is

Line 3215: from ahl_item_groups_vl

3211: attribute12 ,
3212: attribute13 ,
3213: attribute14 ,
3214: attribute15
3215: from ahl_item_groups_vl
3216: Where Item_Group_id = c_itemgroup_id;
3217:
3218: l_itemgroups_det get_itemgroup_det%rowtype;
3219:

Line 3258: from ahl_item_groups_vl

3254:
3255: cursor get_revision_info(c_itemgroup_id in Number)
3256: is
3257: Select 'x'
3258: from ahl_item_groups_vl
3259: where source_item_group_id = c_itemgroup_id and
3260: status_code <> 'COMPLETE';
3261:
3262: l_dummy VARCHAR2(1);

Line 3848: from ahl_item_groups_vl

3844: attribute12 ,
3845: attribute13 ,
3846: attribute14 ,
3847: attribute15
3848: from ahl_item_groups_vl
3849: Where Item_Group_id = c_itemgroup_id;
3850:
3851: l_itemgroup_det get_itemgroup_det%rowType;
3852: