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_NODE_PVT dependencies on AHL_MC_CONFIG_RELATIONS

Line 562: FROM ahl_mc_config_relations

558: FROM ahl_mc_relationships_v rel, ahl_mc_headers_b mch
559: WHERE rel.relationship_id IN
560: (
561: SELECT relationship_id
562: FROM ahl_mc_config_relations
563: WHERE mc_header_id IN
564: (
565: SELECT mc_header_id
566: FROM ahl_mc_relationships

Line 583: FROM ahl_mc_config_relations

579: FROM ahl_mc_relationships_v rel, ahl_mc_headers_b mch
580: WHERE rel.mc_header_id IN
581: (
582: SELECT mc_header_id
583: FROM ahl_mc_config_relations
584: WHERE relationship_id = p_rel_id
585: )
586: AND parent_relationship_id IS NULL
587: AND mch.mc_header_id = rel.mc_header_id;

Line 1186: DELETE FROM ahl_mc_config_relations

1182:
1183: -- ER #2631303 is not valid since there can be no units created from DRAFT MCs
1184:
1185: -- 9d. Delete all subconfiguration associations with the current node
1186: DELETE FROM ahl_mc_config_relations
1187: WHERE relationship_id = l_node_csr_rec.relationship_id;
1188:
1189: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1190: THEN

Line 2669: FROM ahl_mc_config_relations

2665: -- Define cursor check_subconfig_assos to check whether the parent node has any subconfig associations
2666: CURSOR check_subconfig_assos
2667: IS
2668: SELECT 'x'
2669: FROM ahl_mc_config_relations
2670: WHERE relationship_id = p_x_node_rec.parent_relationship_id;
2671: -- Since expired subconfig associations can be unexpired, so no need to filter on active_end_date
2672: -- AND G_TRUNC_DATE < trunc(nvl(active_end_date, G_SYSDATE + 1));
2673:

Line 3482: FROM ahl_mc_config_relations

3478:
3479: CURSOR check_submc_exists
3480: IS
3481: SELECT object_version_number
3482: FROM ahl_mc_config_relations
3483: WHERE mc_config_relation_id = p_submc_assos_id;
3484:
3485: BEGIN
3486:

Line 3533: FROM ahl_mc_config_relations

3529:
3530: CURSOR check_priority_dup_exists
3531: IS
3532: SELECT priority
3533: FROM ahl_mc_config_relations
3534: WHERE relationship_id = p_subconfig_tbl(1).relationship_id
3535: group by priority
3536: having count(mc_config_relation_id) > 1;
3537:

Line 3583: FROM ahl_mc_config_relations submc, ahl_mc_relationships node

3579: (
3580: -- Establish parent-child relationship between subconfiguration associations
3581: -- and the MC to which they are associated
3582: SELECT submc.mc_header_id child, node.mc_header_id parent
3583: FROM ahl_mc_config_relations submc, ahl_mc_relationships node
3584: WHERE submc.relationship_id = node.relationship_id
3585: CONNECT BY node.mc_header_id = PRIOR submc.mc_header_id
3586: START WITH node.mc_header_id = p_subconfig_id
3587: ) submc_tree, ahl_mc_relationships mc_node

Line 3734: /* SELECT 'X' FROM ahl_mc_config_relations

3730: -- SATHAPLI::Bug 9020738, 25-Mar-2010, re-defined the cursor, as hierarchical query is not needed here.
3731: -- Also, changed IN to EXISTS.
3732: CURSOR CHECK_RELATIONS_CYCLE
3733: IS
3734: /* SELECT 'X' FROM ahl_mc_config_relations
3735: WHERE mc_header_id = p_dest_config_id
3736: AND relationship_id IN
3737: ( SELECT relationship_id from ahl_mc_relationships
3738: WHERE mc_header_id = p_subconfig_id

Line 3743: FROM ahl_mc_config_relations cnr

3739: START WITH parent_relationship_id IS NULL
3740: CONNECT BY parent_relationship_id = prior relationship_id);
3741: */
3742: SELECT 'X'
3743: FROM ahl_mc_config_relations cnr
3744: WHERE cnr.mc_header_id = p_dest_config_id
3745: AND EXISTS
3746: ( SELECT 'X'
3747: FROM ahl_mc_relationships mcr

Line 3766: FROM ahl_mc_config_relations WHERE relationship_id IN

3762: -- SATHAPLI::Bug 9020738, 25-Mar-2010, re-defined the query, as hierarchical query is not needed here.
3763: -- Also, changed IN to EXISTS.
3764: /* SELECT mc_header_id bulk collect
3765: INTO l_subconfigs_table
3766: FROM ahl_mc_config_relations WHERE relationship_id IN
3767: ( SELECT relationship_id FROM ahl_mc_relationships
3768: WHERE mc_header_id = p_subconfig_id
3769: START WITH parent_relationship_id IS NULL
3770: CONNECT BY parent_relationship_id = prior relationship_id );

Line 3774: FROM ahl_mc_config_relations cnr

3770: CONNECT BY parent_relationship_id = prior relationship_id );
3771: */
3772: SELECT mc_header_id BULK COLLECT
3773: INTO l_subconfigs_table
3774: FROM ahl_mc_config_relations cnr
3775: WHERE EXISTS
3776: ( SELECT 'X'
3777: FROM ahl_mc_relationships mcr
3778: WHERE mcr.mc_header_id = p_subconfig_id

Line 4098: FROM ahl_mc_config_relations submc, ahl_mc_headers_b mch

4094: -- Define cursor check_submc_exists to check whether the subconfiguration association already exists for this node
4095: CURSOR check_submc_exists
4096: IS
4097: SELECT name
4098: FROM ahl_mc_config_relations submc, ahl_mc_headers_b mch
4099: WHERE submc.mc_header_id = mch.mc_header_id AND
4100: submc.relationship_id = p_x_subconfig_rec.relationship_id AND
4101: submc.mc_header_id = p_x_subconfig_rec.mc_header_id;
4102: -- Since expired subconfig associations can be unexpired, so no need to filter on active_end_date

Line 4381: INSERT INTO AHL_MC_CONFIG_RELATIONS

4377: p_x_subconfig_rec.object_version_number := 1;
4378: p_x_subconfig_rec.security_group_id := null;
4379:
4380: -- Create association record for destination node
4381: INSERT INTO AHL_MC_CONFIG_RELATIONS
4382: (
4383: MC_CONFIG_RELATION_ID,
4384: RELATIONSHIP_ID,
4385: MC_HEADER_ID,

Line 4462: FROM ahl_mc_config_relations

4458: p_mc_config_rel_id in number
4459: )
4460: IS
4461: SELECT active_start_date, active_end_date
4462: FROM ahl_mc_config_relations
4463: WHERE mc_config_relation_id = p_mc_config_rel_id;
4464:
4465: -- Declare local variables
4466: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Subconfig';

Line 4628: UPDATE AHL_MC_CONFIG_RELATIONS

4624:
4625: p_x_subconfig_rec.OBJECT_VERSION_NUMBER := p_x_subconfig_rec.OBJECT_VERSION_NUMBER + 1;
4626:
4627: -- Create association record for destination node
4628: UPDATE AHL_MC_CONFIG_RELATIONS
4629: SET PRIORITY = p_x_subconfig_rec.priority,
4630: ACTIVE_START_DATE = p_x_subconfig_rec.ACTIVE_START_DATE,
4631: ACTIVE_END_DATE = p_x_subconfig_rec.ACTIVE_END_DATE,
4632: LAST_UPDATE_DATE = G_SYSDATE,

Line 4684: DELETE FROM ahl_mc_config_relations

4680:
4681: -- Validate p_mc_config_relation_id exists
4682: Validate_Subconfig_Exists(p_mc_config_relation_id, nvl(p_object_ver_num, 0));
4683:
4684: DELETE FROM ahl_mc_config_relations
4685: WHERE mc_config_relation_id = p_mc_config_relation_id;
4686:
4687: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
4688: THEN

Line 4729: FROM ahl_mc_config_relations

4725: -- Define cursor get_subconfigs to read all valid subconfiguration associations with a particular MC node
4726: CURSOR get_subconfigs
4727: IS
4728: SELECT *
4729: FROM ahl_mc_config_relations
4730: WHERE relationship_id = p_source_rel_id;
4731: -- Expired subconfig associations also need to be copied or else copying position paths will fail
4732: -- AND G_TRUNC_DATE < trunc(nvl(active_end_date, G_SYSDATE + 1));
4733:

Line 4871: INSERT INTO AHL_MC_CONFIG_RELATIONS

4867: -- Set values for l_subconfig_csr_rec
4868: SELECT ahl_mc_config_rel_s.nextval INTO l_mc_config_rel_id FROM DUAL;
4869:
4870: -- Create association record for destination node
4871: INSERT INTO AHL_MC_CONFIG_RELATIONS
4872: (
4873: MC_CONFIG_RELATION_ID,
4874: RELATIONSHIP_ID,
4875: MC_HEADER_ID,