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 1381: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO

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

Line 1422: --Insert in AHL_ITEM_ASSOCIATIONS_B table

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

Line 1472: FROM ahl_item_associations_b b, ahl_item_associations_tl tl

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

Line 1712: DELETE ahl_item_associations_b

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

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

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

2678: END IF;
2679:
2680: DELETE AHL_ITEM_ASSOCIATIONS_TL
2681: WHERE item_association_id IN ( SELECT item_association_id
2682: FROM ahl_item_associations_b
2683: WHERE item_group_id = p_item_group_rec.item_group_id );
2684:
2685: DELETE AHL_ITEM_ASSOCIATIONS_B
2686: WHERE item_group_id = p_item_group_rec.item_group_id;

Line 2685: DELETE AHL_ITEM_ASSOCIATIONS_B

2681: WHERE item_association_id IN ( SELECT item_association_id
2682: FROM ahl_item_associations_b
2683: WHERE item_group_id = p_item_group_rec.item_group_id );
2684:
2685: DELETE AHL_ITEM_ASSOCIATIONS_B
2686: WHERE item_group_id = p_item_group_rec.item_group_id;
2687:
2688: -- Delete ahl_item_groups
2689: AHL_ITEM_GROUPS_PKG.DELETE_ROW(

Line 2707: --Update Ahl_item_associations_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:
2707: --Update Ahl_item_associations_b
2708: -- set INTERCHANGE_TYPE_CODE = 'REMOVED',
2709: -- object_version_number = object_version_number +1
2710: -- Where item_group_id = p_item_group_rec.item_group_id;
2711:

Line 2864: from ahl_item_associations_b

2860: where b.RELATIONSHIP_ID = a.PARENT_RELATIONSHIP_ID
2861: and a.ITEM_GROUP_ID = c_itemgroup_id
2862: and exists
2863: ( select 'x'
2864: from ahl_item_associations_b
2865: where item_group_id = c_itemgroup_id
2866: and quantity > 1 );
2867:
2868:

Line 3435: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO

3431: FOR I IN get_itemgroup_assos_det(p_source_ItemGroup_id)
3432: LOOP
3433:
3434: --Gets the sequence Number
3435: SELECT AHL_ITEM_ASSOCIATIONS_B_S.nextval INTO
3436: l_item_association_id from DUAL;
3437:
3438:
3439: ahl_item_associations_pkg.insert_row

Line 3619: Select ahl_item_associations_b_h_s.nextval

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

Line 3726: Select ahl_item_associations_b_h_s.nextval

3722:
3723:
3724: FOR l_item_assos_det IN get_item_assos_det_csr(p_ItemGroups_id) LOOP
3725:
3726: Select ahl_item_associations_b_h_s.nextval
3727: into l_item_associations_h_id from dual;
3728:
3729: AHL_ITEM_ASSOCIATIONS_H_PKG.INSERT_ROW(
3730: X_ROWID => l_rowid,

Line 4100: from ahl_item_associations_b

4096:
4097: Delete from ahl_item_associations_tl
4098: where item_association_id in
4099: ( Select item_association_id
4100: from ahl_item_associations_b
4101: where item_group_id = l_itemgroup_det.Source_Item_group_id);
4102:
4103: Delete from ahl_item_associations_b
4104: where item_group_id = l_itemgroup_det.Source_Item_group_id;

Line 4103: Delete from ahl_item_associations_b

4099: ( Select item_association_id
4100: from ahl_item_associations_b
4101: where item_group_id = l_itemgroup_det.Source_Item_group_id);
4102:
4103: Delete from ahl_item_associations_b
4104: where item_group_id = l_itemgroup_det.Source_Item_group_id;
4105:
4106: -- The following is to associate the Temporary Item Group Part Numbers
4107: -- to the Permant(Complete) Item Group.

Line 4109: update ahl_item_associations_b

4105:
4106: -- The following is to associate the Temporary Item Group Part Numbers
4107: -- to the Permant(Complete) Item Group.
4108:
4109: update ahl_item_associations_b
4110: set item_group_id = l_itemgroup_det.Source_Item_group_id,
4111: object_version_number = object_version_number+1
4112: Where item_group_id = l_itemgroup_det.item_group_id;
4113: