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_ASSOCIATIONS_B

Line 56: FROM ahl_item_associations_b

52:
53: CURSOR check_priority_dup_exists
54: IS
55: SELECT priority
56: FROM ahl_item_associations_b
57: WHERE item_group_id = p_item_group_id
58: group by priority
59: having count(item_group_id) > 1;
60:

Line 98: FROM ahl_item_associations_b

94:
95: CURSOR check_revision_dup_exists
96: IS
97: SELECT revision
98: FROM ahl_item_associations_b
99: WHERE item_group_id = p_item_group_id
100: group by inventory_item_id,revision
101: having count(INVENTORY_ITEM_ID) > 1;
102:

Line 148: FROM AHL_ITEM_ASSOCIATIONS_B SOURCE, AHL_ITEM_ASSOCIATIONS_B REVISION,

144: SOURCE.inventory_item_id inventory_item_id,
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

Line 255: FROM AHL_ITEM_ASSOCIATIONS_B SOURCE, AHL_ITEM_ASSOCIATIONS_B REVISION,

251: l_inventory_org_id_tbl,
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

Line 768: FROM ahl_relationships_b posn, ahl_item_associations_b iassoc,

764: /*
765: -- Get all the positions associated to this item group.
766: CURSOR get_associated_posns_csr(p_item_group_id IN NUMBER) IS
767: SELECT posn.relationship_id
768: FROM ahl_relationships_b posn, ahl_item_associations_b iassoc,
769: ahl_relationships_b topnode
770: WHERE trunc(nvl(posn.active_end_date,sysdate+1)) > trunc(sysdate)
771: AND iassoc.item_group_id = posn.item_group_id
772: AND iassoc.item_group_id = p_item_group_id

Line 878: --ROW_ID column points to AHL_ITEM_ASSOCIATIONS_B table.

874: p_x_inventory_list IN OUT NOCOPY G_ITEM_DTL_TYPE,
875: x_row_id OUT NOCOPY UROWID) IS
876:
877:
878: --ROW_ID column points to AHL_ITEM_ASSOCIATIONS_B table.
879: CURSOR Item_assoc_csr(p_item_assoc_id IN NUMBER) IS
880: SELECT
881: row_id,
882: item_association_id,

Line 910: l_quantity ahl_item_associations_b.quantity%TYPE;

906: -- Added on 21st Dec 2004 , to allow for Items with different revisions to be added to the same Group
907: l_inventory_item_revision VARCHAR2(3) := '000';
908:
909: l_inventory_org_id NUMBER;
910: l_quantity ahl_item_associations_b.quantity%TYPE;
911: l_uom_code ahl_item_associations_b.uom_code%TYPE;
912: l_master_org_id NUMBER;
913: l_item_key VARCHAR2(200);
914:

Line 911: l_uom_code ahl_item_associations_b.uom_code%TYPE;

907: l_inventory_item_revision VARCHAR2(3) := '000';
908:
909: l_inventory_org_id NUMBER;
910: l_quantity ahl_item_associations_b.quantity%TYPE;
911: l_uom_code ahl_item_associations_b.uom_code%TYPE;
912: l_master_org_id NUMBER;
913: l_item_key VARCHAR2(200);
914:
915: BEGIN

Line 918: -- Check if record exists in ahl_item_associations_b.

914:
915: BEGIN
916:
917: IF (l_x_item_assoc_rec.operation_flag <> 'C') THEN
918: -- Check if record exists in ahl_item_associations_b.
919: OPEN Item_assoc_csr(l_x_item_assoc_rec.item_association_id);
920: FETCH Item_assoc_csr INTO l_item_assoc_rec;
921: IF (Item_assoc_csr%NOTFOUND) THEN
922: CLOSE Item_assoc_csr;

Line 1379: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO

1375: IF (l_item_assoc_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR) THEN
1376: l_item_assoc_rec.ATTRIBUTE15 := null;
1377: END IF;
1378: --Gets the sequence Number
1379: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO
1380: l_item_association_id from DUAL;
1381:
1382: AHL_ITEM_ASSOCIATIONS_PKG.INSERT_ROW(
1383: X_ROWID => l_row_id,

Line 1420: --Insert in AHL_ITEM_ASSOCIATIONS_B table

1416: X_LAST_UPDATED_BY => fnd_global.USER_ID,
1417: X_LAST_UPDATE_LOGIN => fnd_global.LOGIN_ID
1418: );
1419:
1420: --Insert in AHL_ITEM_ASSOCIATIONS_B table
1421:
1422: l_item_assoc_rec.item_association_id := l_item_association_id;
1423: l_item_assoc_rec.object_version_number := 1;
1424: -- Set out parameter.

Line 1470: FROM ahl_item_associations_b b, ahl_item_associations_tl tl

1466: b.ATTRIBUTE15,
1467: b.LAST_UPDATE_DATE,
1468: b.LAST_UPDATED_BY,
1469: b.LAST_UPDATE_LOGIN
1470: FROM ahl_item_associations_b b, ahl_item_associations_tl tl
1471: WHERE b.item_association_id = tl.item_association_id
1472: and b.rowid = p_rowid
1473: AND tl.LANGUAGE = USERENV('LANG')
1474: FOR UPDATE OF object_version_number NOWAIT;

Line 1710: DELETE ahl_item_associations_b

1706: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1707: END IF;
1708:
1709: -- Delete record.
1710: DELETE ahl_item_associations_b
1711: WHERE item_association_id = p_item_assoc_rec.item_association_id;
1712:
1713: DELETE ahl_item_associations_tl
1714: WHERE item_association_id = p_item_assoc_rec.item_association_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 1849: -- Insert into ahl_item_associations_b/_tl.

1845: 'ahl.plsql.ahl_mc_itemgroup_pvt.create_item_group', 'Before loop of Item Association');
1846: END IF;
1847:
1848:
1849: -- Insert into ahl_item_associations_b/_tl.
1850: IF (p_x_items_tbl.COUNT > 0) THEN
1851: FOR i IN p_x_items_tbl.FIRST..p_x_items_tbl.LAST LOOP
1852: p_x_items_tbl(i).ITEM_GROUP_ID := l_item_group_id;
1853: Create_Association(p_x_items_tbl(i));

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 2672: FROM ahl_item_associations_b

2668: END IF;
2669:
2670: DELETE AHL_ITEM_ASSOCIATIONS_TL
2671: WHERE item_association_id IN ( SELECT item_association_id
2672: FROM ahl_item_associations_b
2673: WHERE item_group_id = p_item_group_rec.item_group_id );
2674:
2675: DELETE AHL_ITEM_ASSOCIATIONS_B
2676: WHERE item_group_id = p_item_group_rec.item_group_id;

Line 2675: DELETE AHL_ITEM_ASSOCIATIONS_B

2671: WHERE item_association_id IN ( SELECT item_association_id
2672: FROM ahl_item_associations_b
2673: WHERE item_group_id = p_item_group_rec.item_group_id );
2674:
2675: DELETE AHL_ITEM_ASSOCIATIONS_B
2676: WHERE item_group_id = p_item_group_rec.item_group_id;
2677:
2678: -- Delete ahl_item_groups
2679: AHL_ITEM_GROUPS_PKG.DELETE_ROW(

Line 2697: --Update Ahl_item_associations_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:
2697: --Update Ahl_item_associations_b
2698: -- set INTERCHANGE_TYPE_CODE = 'REMOVED',
2699: -- object_version_number = object_version_number +1
2700: -- Where item_group_id = p_item_group_rec.item_group_id;
2701:

Line 2854: from ahl_item_associations_b

2850: where b.RELATIONSHIP_ID = a.PARENT_RELATIONSHIP_ID
2851: and a.ITEM_GROUP_ID = c_itemgroup_id
2852: and exists
2853: ( select 'x'
2854: from ahl_item_associations_b
2855: where item_group_id = c_itemgroup_id
2856: and quantity > 1 );
2857:
2858:

Line 3425: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO

3421: FOR I IN get_itemgroup_assos_det(p_source_ItemGroup_id)
3422: LOOP
3423:
3424: --Gets the sequence Number
3425: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO
3426: l_item_association_id from DUAL;
3427:
3428:
3429: ahl_item_associations_pkg.insert_row

Line 3609: Select ahl_item_associations_b_h_s.nextval

3605: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_ItemGroups', 'Inserting into History Tables');
3606: END IF;
3607:
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 ,

Line 3716: Select ahl_item_associations_b_h_s.nextval

3712:
3713:
3714: FOR l_item_assos_det IN get_item_assos_det_csr(p_ItemGroups_id) LOOP
3715:
3716: Select ahl_item_associations_b_h_s.nextval
3717: into l_item_associations_h_id from dual;
3718:
3719: AHL_ITEM_ASSOCIATIONS_H_PKG.INSERT_ROW(
3720: X_ROWID => l_rowid,

Line 4074: from ahl_item_associations_b

4070:
4071: Delete from ahl_item_associations_tl
4072: where item_association_id in
4073: ( Select item_association_id
4074: from ahl_item_associations_b
4075: where item_group_id = l_itemgroup_det.Source_Item_group_id);
4076:
4077: Delete from ahl_item_associations_b
4078: where item_group_id = l_itemgroup_det.Source_Item_group_id;

Line 4077: Delete from ahl_item_associations_b

4073: ( Select item_association_id
4074: from ahl_item_associations_b
4075: where item_group_id = l_itemgroup_det.Source_Item_group_id);
4076:
4077: Delete from ahl_item_associations_b
4078: where item_group_id = l_itemgroup_det.Source_Item_group_id;
4079:
4080: -- The following is to associate the Temporary Item Group Part Numbers
4081: -- to the Permant(Complete) Item Group.

Line 4083: update ahl_item_associations_b

4079:
4080: -- The following is to associate the Temporary Item Group Part Numbers
4081: -- to the Permant(Complete) Item Group.
4082:
4083: update ahl_item_associations_b
4084: set item_group_id = l_itemgroup_det.Source_Item_group_id,
4085: object_version_number = object_version_number+1
4086: Where item_group_id = l_itemgroup_det.item_group_id;
4087: