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_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_GROUPS_B

Line 19: from ahl_item_groups_b

15: -- Validation for Create item group.
16: -- TAMAL -- IG Amendments --
17: CURSOR Item_group_csr IS
18: select 'x'
19: from ahl_item_groups_b
20: where name = p_name and
21: nvl(p_item_group_id, -1) <> item_group_id and
22: nvl(p_source_id, -1) <> item_group_id;
23: -- TAMAL -- IG Amendments --

Line 149: AHL_ITEM_GROUPS_B IGROUP, MTL_SYSTEM_ITEMS_KFV MTL

145: SOURCE.inventory_org_id inventory_org_id,
146: SOURCE.revision revision,
147: MTL.concatenated_segments concatenated_segments
148: FROM AHL_ITEM_ASSOCIATIONS_B SOURCE, AHL_ITEM_ASSOCIATIONS_B REVISION,
149: AHL_ITEM_GROUPS_B IGROUP, MTL_SYSTEM_ITEMS_KFV MTL
150: WHERE REVISION.item_association_id = p_assoc_id AND
151: IGROUP.item_group_id = REVISION.item_group_id AND
152: SOURCE.item_group_id = IGROUP.source_item_group_id AND
153: SOURCE.inventory_item_id = REVISION.inventory_item_id AND

Line 256: AHL_ITEM_GROUPS_B IGROUP, MTL_SYSTEM_ITEMS_KFV MTL,

252: l_revision_tbl,
253: l_concatenated_segments_tbl,
254: l_interchange_type_tbl
255: FROM AHL_ITEM_ASSOCIATIONS_B SOURCE, AHL_ITEM_ASSOCIATIONS_B REVISION,
256: AHL_ITEM_GROUPS_B IGROUP, MTL_SYSTEM_ITEMS_KFV MTL,
257: FND_LOOKUP_VALUES_VL FL
258: WHERE IGROUP.item_group_id = p_ItemGroup_id AND
259: REVISION.item_group_id = IGROUP.item_group_id AND
260: SOURCE.item_group_id = IGROUP.source_item_group_id AND

Line 1258: SELECT AHL_ITEM_GROUPS_B_S.nextval INTO

1254: END IF;
1255:
1256:
1257: --Gets the sequence Number
1258: SELECT AHL_ITEM_GROUPS_B_S.nextval INTO
1259: l_item_grp_id from DUAL;
1260:
1261: l_last_updated_by := to_number(fnd_global.USER_ID);
1262: l_last_update_login := to_number(fnd_global.LOGIN_ID);

Line 1729: -- Function : Creates Item Group for Master Configuration in ahl_item_groups_b and TL tables. Also creates item-group association in ahl_item_associations_b/_tl table.

1725: -----------------------------------------
1726: -- Start of Comments --
1727: -- Procedure name : Create_Item_group
1728: -- Type : Private
1729: -- Function : Creates Item Group for Master Configuration in ahl_item_groups_b and TL tables. Also creates item-group association in ahl_item_associations_b/_tl table.
1730: -- Pre-reqs :
1731: -- Parameters :
1732: -- End of Comments --
1733:

Line 1752: l_name ahl_item_groups_b.name%TYPE;

1748: -- Duplicate item association check is now done using G_ITEM_DTL_TYPE, instead of a string.
1749: l_inventory_list G_ITEM_DTL_TYPE;
1750: l_inventory_item_id NUMBER;
1751: l_item_group_id NUMBER; -- sequence generated item group id.
1752: l_name ahl_item_groups_b.name%TYPE;
1753: l_inv_segment ahl_mtl_items_non_ou_v.concatenated_segments%TYPE;
1754: l_row_id VARCHAR2(30);
1755:
1756: BEGIN

Line 1832: -- Insert into ahl_item_groups_b and TL.

1828: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1829: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before calling Insert_Item_group');
1830: END IF;
1831:
1832: -- Insert into ahl_item_groups_b and TL.
1833: Insert_Item_group(p_x_item_group_rec);
1834:
1835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
1836: THEN

Line 1936: -- Function : Modifies Item Group for Master Configuration in ahl_item_groups_b and TL tables. Also creates/deletes/modifies item-group association in ahl_item_associations_b/_tl table.

1932:
1933: -- Start of Comments --
1934: -- Procedure name : Modify_Item_group
1935: -- Type : Private
1936: -- Function : Modifies Item Group for Master Configuration in ahl_item_groups_b and TL tables. Also creates/deletes/modifies item-group association in ahl_item_associations_b/_tl table.
1937: -- Pre-reqs :
1938: -- Parameters :
1939: -- Standard IN Parameters :
1940:

Line 1990: AHL_ITEM_GROUPS_B b, AHL_ITEM_GROUPS_TL tl

1986: TL.LANGUAGE,
1987: TL.SOURCE_LANG,
1988: TL.DESCRIPTION
1989: FROM
1990: AHL_ITEM_GROUPS_B b, AHL_ITEM_GROUPS_TL tl
1991: WHERE
1992: b.ITEM_GROUP_ID = tl.ITEM_GROUP_ID
1993: AND b.ITEM_GROUP_ID = p_item_group_id
1994: AND tl.LANGUAGE = USERENV('LANG')

Line 2530: AHL_ITEM_GROUPS_B b

2526: b.NAME,
2527: b.Status_Code,
2528: b.source_item_group_id
2529: FROM
2530: AHL_ITEM_GROUPS_B b
2531: WHERE
2532: b.ITEM_GROUP_ID = p_item_group_id
2533: FOR UPDATE OF b.OBJECT_VERSION_NUMBER NOWAIT;
2534:

Line 2702: Update Ahl_Item_groups_b

2698: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2699: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');
2700: END IF;
2701:
2702: Update Ahl_Item_groups_b
2703: set status_code ='REMOVED',
2704: object_version_number = object_version_number +1
2705: Where item_group_id = p_item_group_rec.item_group_id;
2706:

Line 2871: from ahl_item_groups_b

2867:
2868:
2869: CURSOR Item_group_name(p_name VARCHAR2) IS
2870: select 'x'
2871: from ahl_item_groups_b
2872: where name = p_name and
2873: p_source_item_group_id <> item_group_id;
2874:
2875:

Line 3013: Update AHL_ITEM_GROUPS_B

3009: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3010: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3011: END IF;
3012:
3013: Update AHL_ITEM_GROUPS_B
3014: Set STATUS_CODE=l_upd_status,
3015: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
3016: Where ITEM_GROUP_ID = p_source_item_group_id
3017: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 3349: Select AHL_ITEM_GROUPS_B_S.nextval

3345: END IF;
3346:
3347: -- Sequence Number for the New Revision.
3348:
3349: Select AHL_ITEM_GROUPS_B_S.nextval
3350: into l_item_group_id
3351: from dual;
3352:
3353: l_last_updated_by := to_number(fnd_global.USER_ID);

Line 3608: from ahl_item_groups_b_h

3604:
3605: -- To get the maximum of version number
3606: Select NVl(max(VERSION_NUMBER),0)
3607: into l_version_number
3608: from ahl_item_groups_b_h
3609: where ITEM_GROUP_ID = p_ItemGroups_id;
3610:
3611:
3612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 3622: INSERT INTO ahl_item_groups_b_h

3618:
3619: Select ahl_item_associations_b_h_s.nextval
3620: into l_item_associations_h_id from dual;
3621:
3622: INSERT INTO ahl_item_groups_b_h
3623: (item_group_h_id ,
3624: item_group_id ,
3625: object_version_number,
3626: creation_date ,

Line 3657: AHL_ITEM_GROUPS_B_H_S.NEXTVAL ,

3653: attribute15 )
3654:
3655: SELECT
3656:
3657: AHL_ITEM_GROUPS_B_H_S.NEXTVAL ,
3658: item_group_id ,
3659: object_version_number,
3660: creation_date ,
3661: created_by ,

Line 3688: FROM ahl_item_groups_b

3684: attribute12 ,
3685: attribute13 ,
3686: attribute14 ,
3687: attribute15
3688: FROM ahl_item_groups_b
3689: WHERE item_group_id = p_ItemGroups_id;
3690:
3691:
3692: INSERT INTO ahl_item_groups_tl_h

Line 3703: AHL_ITEM_GROUPS_B_H_S.CURRVAL ,

3699: created_by ,
3700: description ,
3701: last_update_login )
3702: SELECT
3703: AHL_ITEM_GROUPS_B_H_S.CURRVAL ,
3704: language ,
3705: last_update_date ,
3706: last_updated_by ,
3707: source_lang ,

Line 3974: update ahl_item_groups_b

3970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3971: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');
3972: END IF;
3973:
3974: update ahl_item_groups_b
3975: set status_code=l_status,
3976: object_version_number = object_version_number+1,
3977: last_update_date = sysdate,
3978: last_updated_by = to_number(fnd_global.user_id),

Line 4020: update ahl_item_groups_b

4016: p_src_item_group_id => l_itemgroup_det.source_item_group_id
4017: );
4018:
4019: -- Update the IG with status as complete
4020: update ahl_item_groups_b
4021: set status_code = 'COMPLETE',
4022: object_version_number = object_version_number + 1,
4023: source_item_group_id = NULL,
4024: last_update_date = sysdate,

Line 4139: Delete from ahl_item_groups_b

4135:
4136: Delete from ahl_item_groups_tl
4137: where item_group_id = l_itemgroup_det.item_group_id;
4138:
4139: Delete from ahl_item_groups_b
4140: where item_group_id = l_itemgroup_det.item_group_id;
4141:
4142: -- SATHAPLI::Bug# 4328454 fix
4143: -- Code pertaining to call to AHL_UTIL_UC_PKG.Invalidate_Instance removed.

Line 4161: update ahl_item_groups_b

4157: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4158: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');
4159: END IF;
4160:
4161: update ahl_item_groups_b
4162: set status_code=l_status,
4163: object_version_number = object_version_number+1
4164: where item_group_id=l_itemgroup_det.item_group_id
4165: and object_version_number = l_itemgroup_det.object_version_number;

Line 4253: FROM ahl_item_groups_b

4249: p_item_group_id in number
4250: )
4251: IS
4252: SELECT object_version_number, source_item_group_id, status_code
4253: FROM ahl_item_groups_b
4254: WHERE item_group_id = p_item_group_id;
4255:
4256: CURSOR check_position_exists
4257: (

Line 4459: FROM ahl_item_groups_b

4455: p_item_group_id in number
4456: )
4457: IS
4458: SELECT source_item_group_id, status_code
4459: FROM ahl_item_groups_b
4460: WHERE item_group_id = p_item_group_id;
4461:
4462: CURSOR check_fork
4463: (