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 3339: FROM ahl_mc_relationships_v

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

Line 3957: FROM ahl_mc_relationships_v

3953: -- Define cursor get_node_posref to read the position reference of the MC node, used for displaying errors
3954: CURSOR get_node_posref
3955: IS
3956: SELECT position_ref_meaning
3957: FROM ahl_mc_relationships_v
3958: WHERE relationship_id = p_x_counter_rule_rec.relationship_id;
3959:
3960: -- Define cursor check_uom_rule to check whether the same combination of UOM and rule
3961: -- already exists for the node or not