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 2538: from ahl_mc_relationships_v posn, ahl_mc_relationships_v topnode

2534:
2535: /*
2536: CURSOR ahl_relationships_csr(p_item_group_id IN NUMBER) IS
2537: SELECT 'x'
2538: from ahl_mc_relationships_v posn, ahl_mc_relationships_v topnode
2539: where trunc(nvl(posn.active_end_date,sysdate+1)) > trunc(sysdate)
2540: and posn.item_group_id = p_item_group_id
2541: and topnode.relationship_id = (SELECT reln.relationship_id from
2542: ahl_mc_relationships reln

Line 2542: ahl_mc_relationships reln

2538: from ahl_mc_relationships_v posn, ahl_mc_relationships_v topnode
2539: where trunc(nvl(posn.active_end_date,sysdate+1)) > trunc(sysdate)
2540: and posn.item_group_id = p_item_group_id
2541: and topnode.relationship_id = (SELECT reln.relationship_id from
2542: ahl_mc_relationships reln
2543: where parent_relationship_id is null
2544: start with relationship_id = posn.relationship_id
2545: and trunc(nvl(reln.active_end_date, sysdate+1)) > trunc(sysdate)
2546: connect by prior parent_relationship_id = relationship_id

Line 2553: FROM ahl_mc_relationships

2549: */
2550:
2551: CURSOR ahl_relationships_csr(p_item_group_id IN NUMBER) IS
2552: SELECT 'x'
2553: FROM ahl_mc_relationships
2554: WHERE trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate)
2555: AND item_group_id = p_item_group_id;
2556:
2557: CURSOR ahl_item_comp_csr(p_item_group_id IN NUMBER) IS

Line 2662: UPDATE ahl_mc_relationships

2658: THEN
2659:
2660: IF (l_item_group_rec.status_code = 'DRAFT' and nvl(l_item_group_rec.source_item_group_id, 0) > 0)
2661: THEN
2662: UPDATE ahl_mc_relationships
2663: SET temp_item_group_id = null
2664: WHERE item_group_id = p_item_group_rec.item_group_id;
2665: END IF;
2666:

Line 2859: from ahl_mc_relationships a, ahl_mc_relationships b

2855:
2856: CURSOR validate_item_group_positions(c_itemgroup_id NUMBER)
2857: is
2858: select 'x'
2859: from ahl_mc_relationships a, ahl_mc_relationships 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'

Line 3277: FROM ahl_mc_relationships

3273: -- TAMAL -- IG Amendments --
3274: CURSOR get_mc_posisions (c_item_group_id in number)
3275: IS
3276: SELECT relationship_id, object_version_number
3277: FROM ahl_mc_relationships
3278: WHERE item_group_id = c_item_group_id;
3279: -- TAMAL -- IG Amendments --
3280:
3281: BEGIN

Line 3404: UPDATE ahl_mc_relationships

3400:
3401: -- TAMAL -- IG Amendments --
3402: FOR item_group_rec IN get_mc_posisions(p_source_itemgroup_id)
3403: LOOP
3404: UPDATE ahl_mc_relationships
3405: SET temp_item_group_id = x_itemgroup_id,
3406: object_version_number = item_group_rec.object_version_number,
3407: last_update_date = sysdate,
3408: last_updated_by = l_last_updated_by,

Line 4035: update ahl_mc_relationships

4031: -- copy of the IG, hence no change to the positions
4032:
4033: -- For the positions with temp_item_group_id <> null, such positions are associated to the forked
4034: -- copy of the IG, hence update the item_group_id = temp_item_group_id's value and set latter = null
4035: update ahl_mc_relationships
4036: set item_group_id = l_itemgroup_det.item_group_id,
4037: temp_item_group_id = null
4038: where item_group_id = l_itemgroup_det.source_item_group_id and
4039: temp_item_group_id is not null and

Line 4118: update ahl_mc_relationships

4114: -- This is to update the Master Configuration Node which are associated
4115: -- with 'Draft' Item Group.
4116:
4117:
4118: update ahl_mc_relationships
4119: set ITEM_GROUP_ID = l_itemgroup_det.Source_Item_group_id,
4120: object_version_number = object_version_number+1
4121: Where item_group_id = l_itemgroup_det.item_group_id;
4122:

Line 4262: FROM ahl_mc_relationships

4258: p_relationship_id in number
4259: )
4260: IS
4261: SELECT 'x'
4262: FROM ahl_mc_relationships
4263: WHERE relationship_id = p_relationship_id;
4264:
4265: -- Define local variables
4266: l_api_name CONSTANT VARCHAR2(30) := 'Create_Node';

Line 4350: UPDATE ahl_mc_relationships

4346: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_NODE_NOT_FOUND');
4347: FND_MSG_PUB.ADD;
4348: ELSIF (p_nodes_tbl(i).operation_flag = 'C')
4349: THEN
4350: UPDATE ahl_mc_relationships
4351: SET temp_item_group_id = p_item_group_id
4352: WHERE relationship_id = p_nodes_tbl(i).relationship_id;
4353: ELSIF (p_nodes_tbl(i).operation_flag = 'D')
4354: THEN

Line 4355: UPDATE ahl_mc_relationships

4351: SET temp_item_group_id = p_item_group_id
4352: WHERE relationship_id = p_nodes_tbl(i).relationship_id;
4353: ELSIF (p_nodes_tbl(i).operation_flag = 'D')
4354: THEN
4355: UPDATE ahl_mc_relationships
4356: SET temp_item_group_id = null
4357: WHERE relationship_id = p_nodes_tbl(i).relationship_id;
4358: END IF;
4359: CLOSE check_position_exists;

Line 4468: FROM ahl_mc_relationships

4464: p_parent_ig_id in number
4465: )
4466: IS
4467: SELECT 'x'
4468: FROM ahl_mc_relationships
4469: WHERE temp_item_group_id is null and
4470: item_group_id = p_parent_ig_id and
4471: trunc(nvl(active_end_date, sysdate + 1)) > trunc(sysdate);
4472: