APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 1691: FROM AHL_MC_PATH_POSITION_NODES

1687: x_pos_instance_id OUT NOCOPY NUMBER) IS
1688:
1689: CURSOR get_pos_path_dtls_csr IS
1690: SELECT position_key
1691: FROM AHL_MC_PATH_POSITION_NODES
1692: WHERE PATH_POSITION_ID = p_path_position_id AND
1693: SEQUENCE = (SELECT MAX(SEQUENCE) FROM AHL_MC_PATH_POSITION_NODES
1694: WHERE PATH_POSITION_ID = p_path_position_id);
1695:

Line 1693: SEQUENCE = (SELECT MAX(SEQUENCE) FROM AHL_MC_PATH_POSITION_NODES

1689: CURSOR get_pos_path_dtls_csr IS
1690: SELECT position_key
1691: FROM AHL_MC_PATH_POSITION_NODES
1692: WHERE PATH_POSITION_ID = p_path_position_id AND
1693: SEQUENCE = (SELECT MAX(SEQUENCE) FROM AHL_MC_PATH_POSITION_NODES
1694: WHERE PATH_POSITION_ID = p_path_position_id);
1695:
1696: CURSOR get_position_dtls_csr(c_pos_key IN NUMBER,
1697: c_mc_header_id IN NUMBER) IS

Line 1750: l_position_key AHL_MC_PATH_POSITION_NODES.POSITION_KEY%TYPE;

1746: l_installed_inst_id NUMBER;
1747: l_lowest_unit_inst_id NUMBER;
1748: l_lowest_mc_header_id NUMBER;
1749: l_mapping_status VARCHAR2(30);
1750: l_position_key AHL_MC_PATH_POSITION_NODES.POSITION_KEY%TYPE;
1751: l_last_instance_id NUMBER;
1752: l_requirement_date DATE := p_requirement_date;
1753:
1754: BEGIN

Line 2093: FROM ahl_mc_path_position_nodes mcpp,

2089: CURSOR control_position_check_csr(c_mc_header_id IN NUMBER,
2090: c_position_key IN NUMBER,
2091: c_quantity IN NUMBER) IS
2092: SELECT rel.relationship_id, NVL(c_quantity, mcrs.object_attribute1)
2093: FROM ahl_mc_path_position_nodes mcpp,
2094: ahl_mc_rule_statements mcrs,
2095: ahl_mc_headers_b mch,
2096: ahl_mc_relationships rel,
2097: ahl_mc_rules_b mcr