APPS.AHL_MC_NODE_PVT dependencies on AHL_MC_RELATIONSHIPS_V

Line 558: FROM ahl_mc_relationships_v rel, ahl_mc_headers_b mch

554: p_rel_id in number
555: )
556: IS
557: SELECT rel.ata_code, rel.position_ref_meaning , mch.name
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

Line 579: FROM ahl_mc_relationships_v rel, ahl_mc_headers_b mch

575: p_rel_id in number
576: )
577: IS
578: SELECT rel.ata_code , mch.name, rel.position_ref_meaning
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

Line 1557: from ahl_mc_relationships_v

1553: p_relationship_id in number
1554: )
1555: IS
1556: select POSITION_REF_MEANING,POSITION_NECESSITY_MEANING,GROUP_NAME,ATA_MEANING -- R12 priyan MEL-CDL
1557: from ahl_mc_relationships_v
1558: where relationship_id = p_relationship_id;
1559:
1560: -- 2. Define cursor get_ctr_rule_update_csr to read all counter update rules for a particular MC node
1561: CURSOR get_ctr_rule_update_csr

Line 1596: FROM ahl_mc_relationships_v

1592: p_topnode_id in number
1593: )
1594: IS
1595: SELECT *
1596: FROM ahl_mc_relationships_v
1597: WHERE relationship_id = p_topnode_id;
1598:
1599: -- Define local variables
1600: l_api_name CONSTANT VARCHAR2(30) := 'Copy_MC_Nodes';

Line 1610: l_root_node_csr_rec ahl_mc_relationships_v%rowtype;

1606: l_node_rec Node_Rec_Type;
1607: l_nodes_tbl Node_Tbl_Type;
1608: l_node_csr_rec get_mc_tree_csr%rowtype;
1609:
1610: l_root_node_csr_rec ahl_mc_relationships_v%rowtype;
1611:
1612:
1613:
1614: -- declared by anraj to remove the CONNECT BY PRIOR on joins

Line 3336: FROM ahl_mc_relationships_v

3332: -- Define cursor get_node_posref to read the position reference of the MC node, used for displaying errors
3333: CURSOR get_node_posref
3334: IS
3335: SELECT position_ref_meaning
3336: FROM ahl_mc_relationships_v
3337: WHERE relationship_id = p_counter_rule_rec.relationship_id;
3338:
3339: -- Define cursor check_uom_rule to check whether the same combination of UOM and rule
3340: -- already exists for the node or not

Line 3931: FROM ahl_mc_relationships_v

3927: -- Define cursor get_node_posref to read the position reference of the MC node, used for displaying errors
3928: CURSOR get_node_posref
3929: IS
3930: SELECT position_ref_meaning
3931: FROM ahl_mc_relationships_v
3932: WHERE relationship_id = p_x_counter_rule_rec.relationship_id;
3933:
3934: -- Define cursor check_uom_rule to check whether the same combination of UOM and rule
3935: -- already exists for the node or not