APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 169: from AHL_UNIT_CONFIG_HEADERS UC, AHL_MC_HEADERS_B MC

165: x_route_mtl_req_tbl OUT NOCOPY AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type) IS
166:
167: CURSOR get_mc_dtls_csr(c_instance_id IN NUMBER) IS
168: select UC.MASTER_CONFIG_ID, MC.MC_ID, MC.VERSION_NUMBER
169: from AHL_UNIT_CONFIG_HEADERS UC, AHL_MC_HEADERS_B MC
170: where UC.CSI_ITEM_INSTANCE_ID = c_instance_id AND
171: MC.MC_HEADER_ID = UC.MASTER_CONFIG_ID;
172:
173: CURSOR get_item_from_instance_csr(c_instance_id IN NUMBER) IS

Line 854: FROM AHL_UNIT_CONFIG_HEADERS

850: p_x_disp_req_list IN OUT NOCOPY Route_Mtl_Req_Tbl_Type) IS
851:
852: CURSOR get_sub_unit_mc_csr(c_pos_instance_id IN NUMBER) IS
853: SELECT master_config_id
854: FROM AHL_UNIT_CONFIG_HEADERS
855: WHERE CSI_ITEM_INSTANCE_ID = c_pos_instance_id;
856:
857: CURSOR get_item_grp_for_mc_csr(c_mc_header_id IN NUMBER) IS
858: SELECT item_group_id

Line 1429: FROM ahl_unit_config_headers

1425: MC_HEADER_ID = c_mc_header_id;
1426:
1427: CURSOR get_config_dtls_csr(c_unit_instance_id IN NUMBER) IS
1428: SELECT master_config_id
1429: FROM ahl_unit_config_headers
1430: WHERE CSI_ITEM_INSTANCE_ID = c_unit_instance_id AND
1431: NVL(ACTIVE_START_DATE, SYSDATE - 1) <= SYSDATE AND
1432: NVL(ACTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1433:

Line 1610: FROM ahl_unit_config_headers

1606: p_item_instance_id IN NUMBER) RETURN NUMBER IS
1607:
1608: CURSOR chk_inst_is_unit_csr IS
1609: SELECT 'x'
1610: FROM ahl_unit_config_headers
1611: WHERE csi_item_instance_id = p_item_instance_id
1612: AND nvl(active_end_date, SYSDATE+1) > SYSDATE
1613: AND nvl(active_start_date, SYSDATE) <= SYSDATE;
1614:

Line 1619: FROM ahl_unit_config_headers

1615: CURSOR get_parent_instance_csr IS
1616: SELECT object_id
1617: FROM csi_ii_relationships
1618: WHERE object_id IN (SELECT csi_item_instance_id
1619: FROM ahl_unit_config_headers
1620: WHERE nvl(active_end_date, SYSDATE+1) > SYSDATE
1621: AND nvl(active_start_date, SYSDATE) <= SYSDATE)
1622: START WITH subject_id = p_item_instance_id
1623: AND relationship_type_code = 'COMPONENT-OF'