DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT dependencies on AHL_UNIT_CONFIG_HEADERS_V

Line 1659: SELECT UC_NAME,CSI_INSTANCE_ID FROM ahl_unit_config_headers_v

1655: l_unit_name VARCHAR2(80);
1656: l_root_instance_id NUMBER;
1657:
1658: CURSOR uc_header_information(c_unit_header_id IN NUMBER) IS
1659: SELECT UC_NAME,CSI_INSTANCE_ID FROM ahl_unit_config_headers_v
1660: WHERE UC_HEADER_ID = c_unit_header_id;
1661:
1662: CURSOR get_part_info(c_instance_id NUMBER) IS
1663: SELECT M.inventory_item_id,M.concatenated_segments,C.serial_number,