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 1256: SELECT AHL_ITEM_GROUPS_B_S.nextval INTO

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

Line 1727: -- 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.

1723: -----------------------------------------
1724: -- Start of Comments --
1725: -- Procedure name : Create_Item_group
1726: -- Type : Private
1727: -- 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.
1728: -- Pre-reqs :
1729: -- Parameters :
1730: -- End of Comments --
1731:

Line 1750: l_name ahl_item_groups_b.name%TYPE;

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

Line 1830: -- Insert into ahl_item_groups_b and TL.

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

Line 1934: -- 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.

1930:
1931: -- Start of Comments --
1932: -- Procedure name : Modify_Item_group
1933: -- Type : Private
1934: -- 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.
1935: -- Pre-reqs :
1936: -- Parameters :
1937: -- Standard IN Parameters :
1938:

Line 1986: AHL_ITEM_GROUPS_B b, AHL_ITEM_GROUPS_TL tl

1982: TL.LANGUAGE,
1983: TL.SOURCE_LANG,
1984: TL.DESCRIPTION
1985: FROM
1986: AHL_ITEM_GROUPS_B b, AHL_ITEM_GROUPS_TL tl
1987: WHERE
1988: b.ITEM_GROUP_ID = tl.ITEM_GROUP_ID
1989: AND b.ITEM_GROUP_ID = p_item_group_id
1990: AND tl.LANGUAGE = USERENV('LANG')

Line 2520: AHL_ITEM_GROUPS_B b

2516: b.NAME,
2517: b.Status_Code,
2518: b.source_item_group_id
2519: FROM
2520: AHL_ITEM_GROUPS_B b
2521: WHERE
2522: b.ITEM_GROUP_ID = p_item_group_id
2523: FOR UPDATE OF b.OBJECT_VERSION_NUMBER NOWAIT;
2524:

Line 2692: Update Ahl_Item_groups_b

2688: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2689: 'ahl.plsql.ahl_mc_itemgroup_pvt.Remove_Item_group', 'Updating Item Group to Removed');
2690: END IF;
2691:
2692: Update Ahl_Item_groups_b
2693: set status_code ='REMOVED',
2694: object_version_number = object_version_number +1
2695: Where item_group_id = p_item_group_rec.item_group_id;
2696:

Line 2861: from ahl_item_groups_b

2857:
2858:
2859: CURSOR Item_group_name(p_name VARCHAR2) IS
2860: select 'x'
2861: from ahl_item_groups_b
2862: where name = p_name and
2863: p_source_item_group_id <> item_group_id;
2864:
2865:

Line 3003: Update AHL_ITEM_GROUPS_B

2999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3000: 'ahl.plsql.ahl_mc_itemgroup_pvt.Initiate_Itemgroup_Appr', 'Updating Item group');
3001: END IF;
3002:
3003: Update AHL_ITEM_GROUPS_B
3004: Set STATUS_CODE=l_upd_status,
3005: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
3006: Where ITEM_GROUP_ID = p_source_item_group_id
3007: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 3339: Select AHL_ITEM_GROUPS_B_S.nextval

3335: END IF;
3336:
3337: -- Sequence Number for the New Revision.
3338:
3339: Select AHL_ITEM_GROUPS_B_S.nextval
3340: into l_item_group_id
3341: from dual;
3342:
3343: l_last_updated_by := to_number(fnd_global.USER_ID);

Line 3598: from ahl_item_groups_b_h

3594:
3595: -- To get the maximum of version number
3596: Select NVl(max(VERSION_NUMBER),0)
3597: into l_version_number
3598: from ahl_item_groups_b_h
3599: where ITEM_GROUP_ID = p_ItemGroups_id;
3600:
3601:
3602: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

Line 3612: INSERT INTO ahl_item_groups_b_h

3608:
3609: Select ahl_item_associations_b_h_s.nextval
3610: into l_item_associations_h_id from dual;
3611:
3612: INSERT INTO ahl_item_groups_b_h
3613: (item_group_h_id ,
3614: item_group_id ,
3615: object_version_number,
3616: creation_date ,

Line 3647: AHL_ITEM_GROUPS_B_H_S.NEXTVAL ,

3643: attribute15 )
3644:
3645: SELECT
3646:
3647: AHL_ITEM_GROUPS_B_H_S.NEXTVAL ,
3648: item_group_id ,
3649: object_version_number,
3650: creation_date ,
3651: created_by ,

Line 3678: FROM ahl_item_groups_b

3674: attribute12 ,
3675: attribute13 ,
3676: attribute14 ,
3677: attribute15
3678: FROM ahl_item_groups_b
3679: WHERE item_group_id = p_ItemGroups_id;
3680:
3681:
3682: INSERT INTO ahl_item_groups_tl_h

Line 3693: AHL_ITEM_GROUPS_B_H_S.CURRVAL ,

3689: created_by ,
3690: description ,
3691: last_update_login )
3692: SELECT
3693: AHL_ITEM_GROUPS_B_H_S.CURRVAL ,
3694: language ,
3695: last_update_date ,
3696: last_updated_by ,
3697: source_lang ,

Line 3964: update ahl_item_groups_b

3960: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3961: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Source Item group id is null');
3962: END IF;
3963:
3964: update ahl_item_groups_b
3965: set status_code=l_status,
3966: object_version_number = object_version_number+1,
3967: last_update_date = sysdate,
3968: last_updated_by = to_number(fnd_global.user_id),

Line 4002: update ahl_item_groups_b

3998:
3999: -- Fork the IG to a new one, maintain the earlier complete version
4000:
4001: -- Update the IG with status as complete
4002: update ahl_item_groups_b
4003: set status_code = 'COMPLETE',
4004: object_version_number = object_version_number + 1,
4005: source_item_group_id = NULL,
4006: last_update_date = sysdate,

Line 4113: Delete from ahl_item_groups_b

4109:
4110: Delete from ahl_item_groups_tl
4111: where item_group_id = l_itemgroup_det.item_group_id;
4112:
4113: Delete from ahl_item_groups_b
4114: where item_group_id = l_itemgroup_det.item_group_id;
4115:
4116: -- SATHAPLI::Bug# 4328454 fix
4117: -- Code pertaining to call to AHL_UTIL_UC_PKG.Invalidate_Instance removed.

Line 4135: update ahl_item_groups_b

4131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4132: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Approval Rejected');
4133: END IF;
4134:
4135: update ahl_item_groups_b
4136: set status_code=l_status,
4137: object_version_number = object_version_number+1
4138: where item_group_id=l_itemgroup_det.item_group_id
4139: and object_version_number = l_itemgroup_det.object_version_number;

Line 4227: FROM ahl_item_groups_b

4223: p_item_group_id in number
4224: )
4225: IS
4226: SELECT object_version_number, source_item_group_id, status_code
4227: FROM ahl_item_groups_b
4228: WHERE item_group_id = p_item_group_id;
4229:
4230: CURSOR check_position_exists
4231: (

Line 4433: FROM ahl_item_groups_b

4429: p_item_group_id in number
4430: )
4431: IS
4432: SELECT source_item_group_id, status_code
4433: FROM ahl_item_groups_b
4434: WHERE item_group_id = p_item_group_id;
4435:
4436: CURSOR check_fork
4437: (