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_MC_RELATIONSHIPS

Line 785: FROM ahl_mc_relationships

781: */
782: -- Get all the positions associated to this item group.
783: CURSOR get_associated_posns_csr(p_item_group_id IN NUMBER) IS
784: SELECT relationship_id
785: FROM ahl_mc_relationships
786: WHERE trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate)
787: AND item_group_id = p_item_group_id;
788:
789: -- Get item instances that match the position and inventory_item_id.

Line 2528: from ahl_mc_relationships_v posn, ahl_mc_relationships_v topnode

2524:
2525: /*
2526: CURSOR ahl_relationships_csr(p_item_group_id IN NUMBER) IS
2527: SELECT 'x'
2528: from ahl_mc_relationships_v posn, ahl_mc_relationships_v topnode
2529: where trunc(nvl(posn.active_end_date,sysdate+1)) > trunc(sysdate)
2530: and posn.item_group_id = p_item_group_id
2531: and topnode.relationship_id = (SELECT reln.relationship_id from
2532: ahl_mc_relationships reln

Line 2532: ahl_mc_relationships reln

2528: from ahl_mc_relationships_v posn, ahl_mc_relationships_v topnode
2529: where trunc(nvl(posn.active_end_date,sysdate+1)) > trunc(sysdate)
2530: and posn.item_group_id = p_item_group_id
2531: and topnode.relationship_id = (SELECT reln.relationship_id from
2532: ahl_mc_relationships reln
2533: where parent_relationship_id is null
2534: start with relationship_id = posn.relationship_id
2535: and trunc(nvl(reln.active_end_date, sysdate+1)) > trunc(sysdate)
2536: connect by prior parent_relationship_id = relationship_id

Line 2543: FROM ahl_mc_relationships

2539: */
2540:
2541: CURSOR ahl_relationships_csr(p_item_group_id IN NUMBER) IS
2542: SELECT 'x'
2543: FROM ahl_mc_relationships
2544: WHERE trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate)
2545: AND item_group_id = p_item_group_id;
2546:
2547: CURSOR ahl_item_comp_csr(p_item_group_id IN NUMBER) IS

Line 2652: UPDATE ahl_mc_relationships

2648: THEN
2649:
2650: IF (l_item_group_rec.status_code = 'DRAFT' and nvl(l_item_group_rec.source_item_group_id, 0) > 0)
2651: THEN
2652: UPDATE ahl_mc_relationships
2653: SET temp_item_group_id = null
2654: WHERE item_group_id = p_item_group_rec.item_group_id;
2655: END IF;
2656:

Line 2849: from ahl_mc_relationships a, ahl_mc_relationships b

2845:
2846: CURSOR validate_item_group_positions(c_itemgroup_id NUMBER)
2847: is
2848: select 'x'
2849: from ahl_mc_relationships a, ahl_mc_relationships 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'

Line 3267: FROM ahl_mc_relationships

3263: -- TAMAL -- IG Amendments --
3264: CURSOR get_mc_posisions (c_item_group_id in number)
3265: IS
3266: SELECT relationship_id, object_version_number
3267: FROM ahl_mc_relationships
3268: WHERE item_group_id = c_item_group_id;
3269: -- TAMAL -- IG Amendments --
3270:
3271: BEGIN

Line 3394: UPDATE ahl_mc_relationships

3390:
3391: -- TAMAL -- IG Amendments --
3392: FOR item_group_rec IN get_mc_posisions(p_source_itemgroup_id)
3393: LOOP
3394: UPDATE ahl_mc_relationships
3395: SET temp_item_group_id = x_itemgroup_id,
3396: object_version_number = item_group_rec.object_version_number,
3397: last_update_date = sysdate,
3398: last_updated_by = l_last_updated_by,

Line 4017: update ahl_mc_relationships

4013: -- copy of the IG, hence no change to the positions
4014:
4015: -- For the positions with temp_item_group_id <> null, such positions are associated to the forked
4016: -- copy of the IG, hence update the item_group_id = temp_item_group_id's value and set latter = null
4017: update ahl_mc_relationships
4018: set item_group_id = l_itemgroup_det.item_group_id,
4019: temp_item_group_id = null
4020: where item_group_id = l_itemgroup_det.source_item_group_id and
4021: temp_item_group_id is not null and

Line 4092: update ahl_mc_relationships

4088: -- This is to update the Master Configuration Node which are associated
4089: -- with 'Draft' Item Group.
4090:
4091:
4092: update ahl_mc_relationships
4093: set ITEM_GROUP_ID = l_itemgroup_det.Source_Item_group_id,
4094: object_version_number = object_version_number+1
4095: Where item_group_id = l_itemgroup_det.item_group_id;
4096:

Line 4236: FROM ahl_mc_relationships

4232: p_relationship_id in number
4233: )
4234: IS
4235: SELECT 'x'
4236: FROM ahl_mc_relationships
4237: WHERE relationship_id = p_relationship_id;
4238:
4239: -- Define local variables
4240: l_api_name CONSTANT VARCHAR2(30) := 'Create_Node';

Line 4324: UPDATE ahl_mc_relationships

4320: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NOT_FOUND');
4321: FND_MSG_PUB.ADD;
4322: ELSIF (p_nodes_tbl(i).operation_flag = 'C')
4323: THEN
4324: UPDATE ahl_mc_relationships
4325: SET temp_item_group_id = p_item_group_id
4326: WHERE relationship_id = p_nodes_tbl(i).relationship_id;
4327: ELSIF (p_nodes_tbl(i).operation_flag = 'D')
4328: THEN

Line 4329: UPDATE ahl_mc_relationships

4325: SET temp_item_group_id = p_item_group_id
4326: WHERE relationship_id = p_nodes_tbl(i).relationship_id;
4327: ELSIF (p_nodes_tbl(i).operation_flag = 'D')
4328: THEN
4329: UPDATE ahl_mc_relationships
4330: SET temp_item_group_id = null
4331: WHERE relationship_id = p_nodes_tbl(i).relationship_id;
4332: END IF;
4333: CLOSE check_position_exists;

Line 4442: FROM ahl_mc_relationships

4438: p_parent_ig_id in number
4439: )
4440: IS
4441: SELECT 'x'
4442: FROM ahl_mc_relationships
4443: WHERE temp_item_group_id is null and
4444: item_group_id = p_parent_ig_id and
4445: trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate);
4446: