APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B_S

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 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 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