DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT dependencies on AHL_UNIT_CONFIG_HEADERS_V

Line 1617: SELECT UC_NAME,CSI_INSTANCE_ID FROM ahl_unit_config_headers_v

1613: l_unit_name VARCHAR2(80);
1614: l_root_instance_id NUMBER;
1615:
1616: CURSOR uc_header_information(c_unit_header_id IN NUMBER) IS
1617: SELECT UC_NAME,CSI_INSTANCE_ID FROM ahl_unit_config_headers_v
1618: WHERE UC_HEADER_ID = c_unit_header_id;
1619:
1620: CURSOR get_part_info(c_instance_id NUMBER) IS
1621: SELECT M.inventory_item_id,M.concatenated_segments,C.serial_number,